-
Locking User Abilities
Hello, Is there a way I can lock down users to they cannot remove each other from a sheet? I would like them to be able to edit the sheet but not be able to remove another colleague. Thank you, Alex
-
Turning Off Card View
Is there a way to disable Card View permanently or "shut it off"? Our company uses things in Grid view and we would like to disable the function to avoid confusion.
-
Update Requests, reminders, notifications
I'm wondering if there is a way to set up automatic update requests, reminders, and notifications to be sent on a reoccurring basis until a task has been marked as complete? I see where I can choose to have these emails sent daily, weekly, and so forth. But I don't see where I can tell Smartsheet to stop sending these if…
-
Dashboards | I can see lines in a report of a sheet not shared with me
Hi Using Dashboards, I can see lines in a report from a source sheet that's not shared with me. When I look in the report (and not the dashboard), I cannot see those lines. I assume this is a bug? Michael
-
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…