-
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.…
-
Conditional Logic - Drop Downs
Hi there - I have a form, and am using Conditional Logic to show/hide certain fields, but had a question. Is there a way to show a field and only certain selections from that field? Here's an example: Person selects Retailer A from a drop down. As a result, a drop down (Promotion Options) appears (among other fields). What…
-
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…
