-
Calculate Start Date using a formula
I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on the Assign To person's outlook calendar. Everything works EXCEPT the Start Date field does not seem to allow entering a…
-
Data Mesh: Source vs Target sheets
Hi all, I'm creating a work flow to integrate a number of services that my team offers. There is a work sheet that captures all projects sent our way and assigns them to 1 to 3 services - and those projects show up on their respective work sheets via Data Shuttle. Currently - I have cross sheet formulas set up such that…
-
Datashuttle offload to unique file name or append to file
I see in the existing workflow for offloads that the "action" is replace, can we either have an option to create a new dated file with the date of the execution appended to the name or can we have options to choose to append new data to the export file rather than replace it entirely I would have thought its a relatively…
-
Smartsheet Forum
Hi. I Think a Smartsheet forum should be created so that discussions can happen directly on your organizations portal. And also have an external use feature to include outside vendors to access.
-
Select the column in AJAX for Filter, Workflow and Conditionnal formatting
Hello everyone, Maybe I don't know how to do it that's why I prefer to ask the question before proposing an enhancement: Is there a way to search for a column just by typing the first letters of it so it shows up automatically in any of these section: Filter, Workflow and Conditionnal formatting Because today I need to…
-
Workflow failed due to linked cells. Need help writing formula for Status changes.
I have the following Smartsheet and am trying to automate Status changes based on start and end dates, but from what I've read, I can't do that since my Start Date values are linked cells. Can someone help me write a formula for the Status column to populate either: Not Started, In Progress, Complete, Overdue based on the…
-
Is there a way to restrict number input to positive numbers only in a form?
I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
-
Condition for a workflow: created date is not in the current year
Looking for a solution to move data to another sheet with automation under condition "Created Date is not in the current year". I would appreciate if support.
-
Move a row but only some columns
Hello I am trying to to split a row from a form entry and send 3 columns of that row to another sheet but not the rest of the row. Is there any way to do this without any add-ons? I cant have any vlookup or Index/match on the destination sheet so I have been trying to use a helper sheet but as soon as the first row is…
-
Remove Rows That Are No Longer In Report
I've done a little bit of research and from what I'm seeing there isn't a way (but I'm hopeful you all have a workaround 😀). So I have sheets that contain multiple unique IDs for tasks (they are separated out by manager since we have so many of them) and if a task is deleted on a project plan because it isn't needed…
