Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() fu…
Hello - I'm pretty new to smartsheet, but I'd like to start setting up our 2021 project portfolio for our team. What is the best place to start? Should I copy the project folder for each project and s…
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. …
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and …
Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 …
Hello, I have a row/action that I would like to set an automated weekly reminder. I currently go in weekly to manually put in the reminder. Is there a way to automate this so I get a reminder on this …
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the dat…
Wondering if anybody encountered the same situation here. I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The app…
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works g…
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usu…