Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is not working. Any help you can provide is greatly appreciated!
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. Does anyone know what would be the best way to complete this? Thanks!
Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform all of which have a general response from employees saying this will get added as a possible future update. it has been about ~2-3 years in some cases. As a user community, this is an important function for data…
Has anyone received this error message before? What are the options for large data?
I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am interested in - lets refer to them as an 'open' and 'close' date. I would like to…
Hello, Is there a way for the progress bar of the children rows to roll up to a parent roll where it would display the average in the progress bar form? As you can see in the screenshot, the progress bars are updated with the status of a line item through a formula. Thank you for your help!
Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsheet when they log on with a password but not single sign on. Once logged on they…
When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be linked?
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
