I'm creating a Smartsheet grid with form that will generate a purchase order. There will be an option to add 9 different lines to the PO. Each line has its own variables: Quantity, Unit, Unit Cost, an…
I have a sheet called Employee Data with a State column with State abbreviations in it. I want to move that two digit state abbreviation to a new sheet called Labor Law Reference, column State if the …
Please help with syntax error. I'm trying to check a box if the following is true (in english): IF TEXT is not in Project Long Name column AND Over 90 has content OR IF TEXT is in the Project Long Nam…
I have a date in one row of a Text/Number column (call it Inputs 24). I want to use this cell in a formula in a date column to calculate Due Dates for different tasks. Inputs 24 itself has a Join/Coll…
I have been able to do this before so I'm not sure what I'm missing this time. I have created a sheet that I am the owner for and it is in a workspace where I am an admin. It is a sheet that I want to…
Hello, I need a formula that looks at one entire column. If column is not blank, return the value in that column. There will always only be one value in the column but it may not always be in a specif…
I'm working on a document generation workflow that generates a PO and automatically emails it to external client. It's going well but I have these two questions: Document generator names each pdf that…
I have one sheet with two forms. It's for employee onboarding. One form records some information from the employee and one form records information from the hiring manager. Two new rows are created in…