-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
Smartsheet Not Working Properly
Hi, Since yesterday in the afternoon, we've been having some issues with two things: 1- Comments are not working when you try to edit them from the search section. When you actually click into the sheet, it works. 2- Some of the people in the office are receiving their email notifications italicized. What can be done to…
-
Automated Alerts - Comments
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 sheet and so the option to include a link to the sheet with selected columns included is not an option. Is there a way to…
-
Using INDEX/MATCH with images
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/MATCH to bring in info from several others and I would like to be able to bring in these images from their source document.…
-
Automated symbol isn't switching
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 to 100% mark it green. This is what I got: =IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target…
-
NEED TO ADD LAST COMPLETION DATE IN COMPLETION DATE COLUMN
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 Completion Date will register the date of last row that changed to "complete" status. NOTE: The Record a date automated workflow…
-
Why Can't I Check a Checkbox in a report?
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 check/ uncheck while in the report, (which will update the sheet that it pulls from), and the other two columns are unable to…
-
How to Hide Sensitive Data in Shared Sheet
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 that? Thank you?
-
Issues with Cross Reference and VLookup
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. In order to provide data for testing, I cut down my files to remove sensitive data and just included the necessary data, now…
-
Filter by formula
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 need to input a manual number instead of deriving from a formula. My current situation is that I'm using reference manager to…