-
Triggering an automation from an attachment revision
Hi - I am trying to trigger an automation when I upload a revision to an attachment. I already have the document generated by changing a field and then when I upload the revision, I want the same field to change again. For some reason, I can't seem to trigger from the revision. I tried setting the trigger to a new…
-
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
-
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
-
Sheet Title Formula?
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know…
-
What would be the formula to only count parent row items with the "in progress" statuses
Hello Everyone, I am new to Smartsheet and I am struggling with identifying a Smartsheet formula for one of my sheet. I am attaching an example image for reference. Here, I have three columns with headings "Only Projects", "Project Name", "Status". I would like my "Only Projects" column to display the value "True" against…
-
Form Submissions causing duplicate names on sheet
hi there! my department is sending out forms to various departments, and when they fill in the form and submit it, it adds the entry to the bottom of the sheet. my problem is I already have the names listed on the sheet, so their names are being added twice. is there a way to delete the name that is blank above once the…
-
IF formula to return date based on drop down selection
I have a formula that is working correctly returning a date based on a drop down selection. Now I need to incorporate business days into that return date instead of total day. I have 3 columns i'm working with, Priority, Requested date and Request due. The user will enter the date the request is received and select the…
-
How can I get the column to accurately track hours elapsed?
Hello! Trying to have Total Time calculate total hours elapsed from Start Time to End Time. I created "helper" columns based on another question's answer, but it didn't help. We use 24-hour clock here and I need the column formula to consider that some values will start before midnight and end after midnight and will…
-
Countifs f-la
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…
-
Get Earliest Date from Range Given a Second Criteria
Hello, I have a column of Dates and a column of Names. What formula can I use to return the earliest Date from the Date Column for a given Name? Thanks.
