-
Using TODAY() as a date range
Hi All, I was hoping to be able to use the TODAY() function as part of a date range check using the IF and AND functions then using column name >= TODAY, column name <= TODAY() in a nested IF statment. =IF(Complete1 = 1, "Up", IF(Start1 = TODAY(), "Angle Up", IF(AND(Start1 >= TODAY(), Finish1 <= TODAY()), "Sideways",…
-
Remove User from Enterprise Level
Good morning, In the Team level, I had access to a report that showed me all Users per sheet/report, so that when someone left/changed departments, I could easily see what access they had. This report is no longer available to me since we went to the Enterprise level, and our SysAdmin says that the report only shows them…
-
Project Team Widget
I want to make a dashboard widget for my project that shows a report containing all individuals that were assigned a task in said project. I know that the "assigned to" column can be pulled in a report, however it shows multiple instances of each person because each person does multiple tasks in each project. Is there…
-
Parts of a whole inventory suggestions
Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update it there so that it…
-
Dashboard View
Good Afternoon, I'm interested to see if the capability exists to change the orientation of dashboards. This may be basic, but it seems that portrait orientation is about all you get unless you limit the amount of information and customize the orientation in the print function. Does anyone know of any other way? Thanks a…
-
=if function with networkdays
I am attempting to write a formula where I can look at a date field and if it is blank have the formula calculate networkdays between two fields and if the date field is not blank then calculate the networkdays between a different two fields. I have this as my formula: =if([Order Approval Date]2 ="",NETWORKDAYS([OAM…
-
Retrieve deleted sheets
Hi, We accidentally deleted the sheets in our accounts, because we want to change the plan. Case number 02911830 Can you please help us how to get back the sheets that were deleted from "deleted items"? Thank you, Divya
-
Project Management/PMO tips
Hi All, I'd be interested to hear how others are setting up smartsheet to support large programmes involving many projects, with multiple organisations, exec sponsors, and project managers. I work in the National health Service (UK) and have a master project list that contains summary information for around 200 projects,…
-
Discussions: Email a Comment
Smartsheet, In the Discussion feature, I find myself needing to write a comment - then click SAVE - then click on the "Email Comment" button - then fill out the person's (or people's) names in the discussion and then click send to get the comment out to the Team. Is there a way - OR can you add a feature - that allows me…
-
Maintaining Formulas When Sorting a Sheet
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…
