-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…
-
VLOOKUP - reference sheet, based on two criteria
Hello, Is it possible to use a VLOOKUP formula to pull data from a reference sheet based on conditions in the original sheet? I have two things I am trying to have automatically calculated in my original sheet: # of Team Members (based on the Total Enrollment and Classification columns on this sheet that tell me what…
-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
How do I trigger an automation on a sheet that is not open?
The problem: The "on change" automation does not trigger despite the flag changing - this is happening on a sheet that is not running. The situation: I have 2 sheets. Sheet 1, The Active List, has a list of active employees. Sheet 2, The Remove List, is populated via data uploader (replace). It contains employees who leave…
-
Formula to Automate Dates
Hi! I am looking for a formula for my "Actual End" Column that will auto-fill the date when the "Assigned To" statues a task as "Complete. Can anyone help with this? Krista
-
Need assistance on #Invalid Operation result
I'm trying to create a formula in a parent row to return the most common value of its children (High, Medium, or Low) and keep getting an #Invalid Operation error If there are equal or more highs than mediums or lows, the parent status should be High. If there are equal or more mediums than highs or lows, the parent status…
-
Status update to Full depending on drop down list selection
Hi There, I'm attempting a formula based on the responses of certain calls that come in or calls we make. There are 4 columns total where we are either calling out to somebody and trying to track response, or they are calling back in and we complete the employee. When we call out, we have to call out every 2 days up to 3…
-
If statements
I am trying to generate a 1, 2, or 3 depending on if certain cells have text in them. So far I have =IF([Invoice Number]@row = " ", "1" , "2"), IF([Paid Date]@row = "<>", "3" ,"2") What I need is if invoice number is empty a 1. if invoice number is full and paid date is empty a 2. if invoice number is full and paid date is…
-
Rental Availability Formula
I am trying to make a formula in smartsheets where I can check availability. We have a current schedule that consists of events where a trailer is booked out between dates. I have formula that will give me the daily count of how many trailers are booked on a particular day. =11 - (COUNTIFS([Restroom Trailer]:[Restroom…
-
Is Automation Workflow can be triggered by Formula resulted change?
Hi there, I am trying to make a task automation with multiple steps. The idea is I have a master sheet where the task is being copied to from reference sheet (where all tasks in there). The Logic is, when the first task in the master sheet is completed, the second task row will be copied to the master sheet. I have a…