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 am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
I have a risk sheet with a system generated id column (ACT-0001); etc. In the risk sheet I have a helper column to identify if the risk is linked to a task in my project plan sheet. In my project plan sheet, I have a column called RiskID that contains a string of risks (ACT-001; ACT-0002; etc.) linked to a task. The risks…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
