In an approval workflow when someone is notified on the Approved/Declined status, we have built a "message only" alert back to the user who submitted the request. The user will never be shared to the …
Hi all, Is it possible to use an INDEX/MATCH formula to bring an image from one sheet into another? If not, anyone recommend a solution/ work around? I am building a new sheet that utilizes INDEX/MATC…
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal …
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Complet…
I haven't had issues with this in the past, it suddenly is no longer working. So weird. I have a report that has 4 columns that can be checked / unchecked. Today, 2 of the columns are allowing me to c…
Hello, I would like to share a sheet with my team/editors however would like to keep certain columns hidden as they contain sensitive data that does not pertain to their roles. Is there any way to do …
I have been trying for several days to get cross referencing to work, it is stuck in the processing status is what I have noticed. I even tried to use different browsers to see if that was an issue. I…
I have several columns which I typically have a formula in nearly every row (like you would use a column formula) but I've decided to have the formula be cell based because every once in a while, I ne…
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another shee…
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only…
