-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
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…