-
Hide #INVALID DATA
Hello, I am attempting to calculate the difference between two dates. When one of the dates is missing, the cell where the difference would be shown instead contains "#INVALID DATA". Can anyone please help? I've attached a screenshot. The "Actual Duration" column is the difference between the "Start Date" and "End Date". I…
-
Problems with Levels in Card View Mobile
Hello! Does anyone else have issues with Levels in Card View on mobile (Android)? It appears that the Level view gets reset when leaving sheet -- and even worse, If I set the display to "Level 1 and subtasks", and then I add a subtask, it will switch the display to "Level 2"! (and all my main tasks will disappear). I was…
-
automatic reminder triggered by the system generated created (date) field
I want to create a reminder to be sent automatically 5 days after the system-generated create (date), if another column is blank. The system-generated column with the create(date) does not show in the dropdown of options for the date field. Has anyone else run into this, and if so, any suggestions on how to get the…
-
Smartsheet Excellence - worth it?
Looking into either Smartsheet's excellence training or another bigger picture project management training. Does Smartsheet's excellence courses provide value beyond just the Smartsheet tool? Basically, I'd prefer something I can grow my project management training that doesn't tie me to a specific tool (even though we'll…
-
Update Request Form
Hi, I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated? The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start Date is in the past Send…
-
Adding New Items During Update Request
I have a report page where I've been testing the "Update Request" feature through a custom form. It works well for updating existing information, but is there a way to also add new line items with that request? For example: If I am sending an "Update Request" for a user to review a list of existing fruits and vegetables…
-
Formula for auto flag
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end date] - today()<=7,0.5.0). It turns the flag red when it falls into the not 80% complete in the time frame but when there…
-
% of usage for resources
Hi, everyone! I have created the task in smartsheet and alocated 3 resources to it. F.e: developer1, developer2, developer3. The usage of these recources is deifferent. Developer1 - 50% Developer 2 - 30% Developer 3 - 100% How can I can submit in in smartsheet to see correct resource plannig?
-
How to make a chart that calculates total sales by payment meothd?
Hello! I have a sales sheet indicating many information among of which is the total of each sale and the payment method (either cash or cheque). I made a report to group only sales from this month, with both payment methods, I wanted to add a widget to the dashboard from this report that will show total sales by cash and…
-
Help with dashboards
Hi, I'm Creating my dashbord to manage some sheets. I've already included the widgets but i can't include a standard filter for each sheet. (like in the classic edition page). All sheets opens with filter off. How can I set a standard filter? Thanks