Create a Cell that can summarize what's missing in other cells of the same line?
Sorry in advance, I may over-write / overexplain because 1. I'm lame at explaining and 2. English is not my first language ^^'
In my work, I need to do a release checklist, with multiple checks. Each check is a cell saying for example "Date OK?", or "Price in database?" etc etc. I fill this cell with "OK" if it's done, or I write why it's not done yet to have a clear view of what I still have to do. For example if the price is not in the database I'll put "Ask partner by mail again" or anything, this cell is "free" when I write something, except for the "OK" which means it's good.
Here is an example of how it was in Google Sheets (of course the colors were set automatically \o/):
I'm trying to move this file to Smartsheet because it is very annoying to transfer informations between my main file in Smartsheet with all the data (used by the whole company) and this checklist on Google Sheets (and I have to keep tracks of all changes in my Smartsheet file to report them in the release checklist one, yada yada yada).
Now, knowing that Smartsheet is powerful, I am wondering if I can make a column that will resume the state of a range of columns (the ones I use for my release checklist). In the case of the picture above, this summary cell will say "Issue sending build" or something like this. And I'd like it to check if there is an issue for all the cells in a range, and write a little standard text (probably the column name) in this summary cell, to have a very quick glance of what I still need to do. I have ~20 cells to fill for my release checklist so I'd like to avoid to scroll in my Smartsheet all the time ^^
I thought aligning multiple "If" like Excel authorize (cf capture below) but it doesn't seem to work.
If someone has an idea or want some more explanation, or just insult me and my stupid questions, you're more than welcome :D
On a related topic: it was easier in Google Sheets to say "If this cell starts with "OK", then put it in green" and apply this to a whole range of cells, it seems I have to do it column per column in Smartsheet?
Help Article Resources
Check out the Formula Handbook template!