I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I…
We have several partners who also use Smartsheet and may want to consolidate work under one Workspace. Any advice? I don't know if you can simply "Make an Owner". Thanks in advance!
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all …
Hello, I noticed the Empty status of the Harvey ball is now a blank instead of an empty circle. Was there a reason for this change to make this operation less useful? The selections used to be Empty (…
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something …
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive int…
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated pr…
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a…
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but cur…
Hello! I'm a new user/licensee of Smartsheet! Is it possible to attach files/docs to a row via Power Automate? I've set up a simple flow to create rows on a sheet each time an email arrives in a share…
