-
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…
-
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
A lot of work environments operate primarily on weekdays but have some scheduled milestones that need to happen weekends. Current settings only allow you to have all items in the sheet count weekends or all items in the sheet count weekdays. It would be a lot more functional for schedule building if you could make some…
-
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?