Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that woul…
Hi, has anyone figured out a way to send an approval request for more than one row at a time? I have rows that all need approved that need to be sent in the approval request along with their informati…
I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task …
Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and…
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 colum…
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns t…
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I us…
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will …
I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks t…