-
Using SmartSheet for Discussions/Messages/Threads
Hello! We've been using SmartSheet for the last ~9 months and love many of its features (e.g. project plans, Risk, Actions, and Issue Logs, etc). One use case that we haven't been able to find a great solution for, however, is basecamp like message boards/discussions (https://basecamp.com/features#message-boards). How have…
-
Conditional Formatting using a custom formula?
Hi there, So I'm trying to set up conditional formatting to visually alert us if 3 days go by and we haven't followed up with someone. My idea is to make an "Estimate Sent" cell which records the date we sent an estimate and turn it red if we haven't checked the "Estimate Approved" column after 3 days go by from the date…
-
University Permit or Special Event Request From
Hello, I am wondering if anyone in this group uses Smartsheet for Permit or Special Event applications? We are looking to utilize Smartsheet to streamline our Alcohol Permit process and I wanted to see if anyone is already using Smartsheet for something similar. Thank you in advance!
-
Design Question
I have taken over management of our sheets for my department and have been trying to redesign them to make them more fluid, functional and all around nicer and implement it at the start of the year. We use Smartsheets for construction projects. We maintain a bid list of all projects bidding and ones that have bid during…
-
The behavior of Duration, Start Date, and End Date fields when dependencies are enabled
Thought sharing what I learned about editing these fields in a sheet vs a report could be helpful to others. Please note that this only applies when dependencies are enabled on the project settings. On the sheet when they are all blank, indicate any 2 and Smartsheet calculates the third After there's already data on these…
-
Formula to add "No" to a blank cell, but leave value if not blank
On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking for a formula to replace those blank cells with "Does Not Apply" but leave a value there…
-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…
-
Week Ending Date on Dashboard - Automatic Update
Hello, how can I leverage the metric widget in a project Dashboard to display 'Week Ending X/XX/XXXX' that updates automatically? For example, for the week of 11/8/21-11/12/21, I would want the widget to show Week Ending of last week (11/5). When it becomes 11/15/21, I would want it to display 'Week Ending 11/12/21'. Do I…
-
How to Archive a Workspace
I have several workspaces for closed or past projects that I would like to archive. We do NOT have Control Center. I act as more of an admin (and I'm also a Smartsheet Admin) for the owners of the project. I would want them to continue to be able to access their old data, should they need to. Is there a way to do this…
-
Automation - need a required for meeting reminder
Hi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and stakeholders which they then reply to if they can make the cal. I have made a required members tab, with multiple contacts in…
