-
Email Reminder When Task is 100% Complete
Is there a way to automatically send a email when a tasks completion column is changed to a 100 % complete?
-
Power Function from Excel
I converted a power function from excel "=0.8*(POWER((9600/1000),-0.5))" and once imported it comes up as an "unexpected opperator". Is there another work around?
-
Conditional Formatting editing
Hello, Is there a way to delete a condition(s) from a rule without deleting the entire rule? Or do you have to delete the entire rule and start over with a new rule?
-
Conditional Formatting organization
Hello, Currently the only way to organize all of your conditional formatting rules in a sheet is to "Move to Top" or "Move to Bottom" one by one. If we have tons of rules in a sheet, this can be extremely time consuming. Is there a way to quickly organize rules by priority? Please advise.
-
Answered: How to offset a date picker
Hello SC, I have a staff request for leave smartsheet. I want to have the date picker 2 weeks forward, so that you cannot select a date within the immediately following 2 weeks. So, any date up to 2 weeks from now should be greyed out. Any ideas?
-
Reminders based on multiple criteria
Hi, The only trigger available is based on dates which is fine but I need to add a condition such as "unless item closed". Do you know of a way I can achieve this, first of all is it a feature available? Thanks,
-
is there a way the color of boxes in the list view can automatically show in the gantt chart? i
it's very time consuming having to select each individual box in the gantt chart to match the colors in list view.
-
Restore a prior iteration?
Gant function threw off all my external links in a prticular column. Not knowing this had happened, I had saved the work. Is it possible to restore a prior iteration of smartsheet?
-
Property Management templates
Smartsheet kindly has given us a couple of templates. I am looking for more ! . We are an insurance supplier and our Property Management firms are smaller than the superb case studies here. Of course, the templates can become simple ( but the education and creative is not easy). If I can be so bold as to humbly ask for…
-
Main Template sheet
I have a main sheet that gets better and better everytime. I want it to link to all the sheets. So lets say I have 15 homes that Im building and we use a sheet for each of them. Well when we make the sheet different I would like it to change with all the sheets. So I dont have to manualy enter all the different items per…
