-
Dynamic Charts
Is there a way how the charts in a dashboard can be updated automatically as one add new rows to a database? Thank you.
-
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…
