-
SumIF formula help
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
-
Alternative to unnecessary browse button change
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Merged: We need a way on a Project Schedule to delineate certain items can be completed on the weekend without turning it on for the whole sheet
This discussion has been merged.
-
Interactive Graphics
Here is my goal: I need to create an image where the image has multiple areas. If one clicks on the that are (much like an image map in HTML). Then I need a secondary window to open where the use would select the status on that area. In Progress, not Started, Complete. But also I need it to show the last note added to that…
-
Web Version Loads The Same Sheet
Hello, With the new update I'm experiencing an issue I didn't have before. I use Smartsheet web version because I typically work with 20-30 tabs open and it makes it easier to use than the app. Since this new update, every day when I open my laptop I am prompted to log in (as usual), but when the sheets load they all open…
-
Enable attachments in automations when using 'message only' option
We receive data from externals which we then need to verify. Once it's verified we then email them back a PDF (that's been generated using 'generate document' feature) as it contains the crucial information that's been verified, and they can keep as a confirmation. Currently, I use the message only format in an alert…
-
Merged: Add Attachments to message only feature
This discussion has been merged.
-
Anyone else having issues with search in board view not returning results?
I've just got a new team using Smartsheet in board view for easier collaboration. One issue though, is the search function is only returning matches when they're in the primary column - not in any other field. This isn't ideal and must be a bug. I've logged it as such but keen to know if anyone else is having the same…
-
Copy text in Conversations
Why can't i copy a text message that was posted in the Conversations tab? Did this change with the last update as i was always able to do it?