Sign in to join the conversation:
I want to transfer a line from one sheet to another when a certain criterion is given. how can i do it?
Hi,
You could set this up with the help of a service like Zapier or similar.
Would that work for you?
Best,
Andrée Starå - Workflow Consultant @ Get Done
I have used the index/match formula successfully , but in my current project, for some reason it isn't working. I have my two sheets (Open Adp) and (A/N Referrals). In Open Adp, there is a Case ID and then a person's name associated with that ID. I'm trying to have the person's name from Open Adp sheet be pulled over into…
Hello, I have task 3 which is dependent on task 2 and task 1. I want task 3 to start when either task 2 or task 1 is completed. How do i implement this in Smartsheet gov? below is a screenshot of what I tried but it does not seem to work. Any suggestions?
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?