Hi guys, I’m trying to export a CSV with the full status name and not the short code.
Does any one know if it is possible?
Thanks!
You can make a custom CSV exporter that replaces the status code with its name field, or for a much easier approach, write an Excel/Sheets macro that does this for you based on a matrix.
2 Likes
Thanks for the idea, Alfonso. I had tried building a script in Google Sheets, but it was taking too long for the more than 1,000 tasks I have. I ended up creating a new calculated field in Flow that could change it for me, and it works much faster. However, it has a character limit, so it might be a problem for someone who has too many options.
IF({sg_status_list}=“rev”,“Pending Review”,IF({sg_status_list}=“pendir”,“Pending Director Review”,IF({sg_status_list}=“penflx”,“Pending Netflix Review”,IF({sg_status_list}=“apvtmp”,“Approved - Temp”,IF({sg_status_list}=“apr”,“Approved”,IF({sg_status_list}=“kb”,“Kickback”,IF({sg_status_list}=“ip”,“In Progress”,IF({sg_status_list}=“omt”,“Omit”,IF({sg_status_list}=“hld”,“On Hold”,IF({sg_status_list}=“wtg”,“Waiting to Start”,IF({sg_status_list}=“fin”,“Final”,TO_CODE({sg_status_list}))))))))))))
Another option would be to do this mapping in Google Sheets, using a lookup of the short value to a table mapping short to long values?
1 Like