-
Cross Sheet Functions Don't Update Quickly
TLDR: I have sheets with interrelated information that need to update concurrently. It works, but there's a lag, and I'm often forced to hit refresh on multiple sheets to get all the data to shake out. I can't role this out to my group like this because it's too manual. I need the sheets to update faster, or at the very…
-
automatically mark multiple rows when one row is marked
Is there a formula to check all the boxes with the same account number when one is checked? For example, Account 10-111 has 3 owners. When we receive a vote from anyone of them, we will choose the method the vote was received and check a box under the valid or invalid vote columns. Is there a way to cross out all three…
-
adjust date calculation formula to count calendar days instead od workdays
Hi - I have 2 date fields: Travel End Date - entered manually REIM DUE DATE – needs to be “Travel End Date +30 calendar days” The formula below works but it counts 30 workdays after Travel End Date. How to I correct it to be 30 calendar days after Travel End Date? =WORKDAY([Travel End date]@row, +30) Thank you!
-
What is wrong with my formula?!?
Hi all I am using the following formula to tell me if a certain selection is made and another entry is greater than or equal to 12, but for some reason it is still flagging as Yes even when the cell is less than 12. What am I doing wrong? =IF(AND([12 Hour Notification]@row >= "1", [Estimated Duration of Fire System…
-
IF OR Formula maybe Contains
Multiple job types produce the same number of days. I want to simply the formula without having to write each type out but I keep getting errors. I know this works for just one but how can I rewrite for the formula to be IF its this job type or that job type or that job type = this number of days. Not sure if I should be…
-
IFERROR(JOIN(COLLECT multiple sheets
Hi, I am trying to build a formula in a sheet with a list of order numbers ("global order list" sheet) to search collect and join the product details contained in three different sheets ("EMEA product details", "APJ product details" and "Americas product details" sheets). In the "regional" sheets the order number can…
-
Struggling with an IF formula I feel should be simple.
What I am trying to do is this: If the Status is Satisfied, Health is Green If the Status is Concerned, Health is Yellow If the Status is At Risk, Health is Red Tried: =IF(Status = "Satisfied", "Green", IF(Status = "Concerned", "Yellow", IF(Status = "At Risk", "Red")))
-
How to Count the Number of Times a Row has a Specific Combination of Values
I am having a hard time counting the number of times a combination happens in a single row in my sheet - There are formulas that affect one another, making it difficult for me to figure out. Here's some background... My sheet is tracking photos I need taken by a photographer. Each singular row represents an image (the…
-
Assistance With Cross Sheet CountIFS Formula
Hello everyone, I'm putting together a bar chart for a dashboard that uses several cross-sheet ranges. The formula works and I was able to put a basic table together with the "Department Affected" as the vertical axis of the table. The function is pulling from 3 ranges on a source sheet, each pulling form a different…
-
I have a column of numbers and need to detect if a duplicate is being entered.
Ideally, Smartsheet would allow me to specify that the data for a cell has to be unique, ie, never used before in the column. Lacking that, I can create an adjacent field, say a check box, that gets checked when a formula detects that the actual data cell just had a duplicate entered. Is this possible? First time poster!…
