-
Date rollback
Hi All I'm having difficulty with my date formula's. i have a few in a sheet that i'm using to display today's date and a range of important dates as well as auto adding figures =SUMIF({Tokoroa orders}, TODAY(0), ({Tokoroa Orders out Range 1})) and =TODAY() my issue is that unless i manually go into the formula page all…
-
Regional Default Date format
Since the major outage earlier today (NZ time was not affected, thankfully) we have a VERY unstable date format, with frequent switches away from our regional default dd/mm/yy to the 'american' format of mm/dd/yy. The Smartsheet refresh icon makes no difference at all, but the Web refresh icon can fix it on one attempt,…
-
Smartsheets Down?
I am unable to access smartsheets from any of my devices. Is this just me or is anyone else also experiencing issues. Update: I found this link: https://status.smartsheet.com/
-
What happens to Workspace items, if existing owner is not with the company?
Hi, I have a quick question; although I do know about the System Admin capability that allows it to transfer the ownership of items to a new user via User Management option. But does it also transfer items which that user owned in a Workspace (not workspace but the items on it!)? If yes, then I am good :) If no, then what…
-
Formula to automatically check the checkbox in a "complete" column
I'm using RYGG balls to indicate the status of a row. Grey represents complete as a colour. When a cell is changed to grey in the status column, I'd like for the checkbox in the "complete" column to automatically be checked. What formula would I create to complete this task?
-
Sharing Multiple Sheets with a User at Once
Is it possible to share multpile sheets with a user at once? I have several sheets that I would like to make accessible to one of our users, and the only way I know of to do this currently is to go into each sheet and share one at a time. Is there a faster way to do this? Also, can I quickly view who is currently shared on…
-
hiding columns or data for certain users
I'd like to add budget data to a project sheet but hide that info from certain users. Is this possible? And is it possible to have the sum of amounts in sub-tasks appear in the cell of the main task?
-
Adding Task/Status to Dashboard
Does anyone know how to add the below screenshot to a dashboard? I would like to include task and status and the corresponding gantt chart to my dashboard. I would only like to include the status for projects that are indented 3 times on my chart though.
-
How to stop due date reminders once task has been completed
HI- We use Smartsheet for tasks that need to be completed by several people. We currenlty have reminders set up for due dates (both 5 days before due date and past due date). Is there a way to NOT send the reminder if the task has been completed/the 'Date Completed' field has a date in it?
-
Cross-Link Dependencies
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt…
