-
Create a cross refference formula that meets multiple criterias
I am looking to Create a cross-sheet reference formula that meets multiple criteria. see screenshot
-
Using checkbox to add value in another cell.
I am not an expert on excel but I am trying to add value (more specific: adding date/time or just time automatically) to another cell just checking a check box cell. Is this possible on smartsheet? Thanks. Al
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
CountIfs Invalid Ref
I cannot for the life of me get this CountIfs function to work. Referencing another sheet. Plz help! =COUNTIFS({FY23 PWP Meets Objective:Meets Objective}, "No", {FY23 PWP PHC:PHC}, "FFH") Screenshot of my reference sheet columns and values.
-
Issue with CountIFs function
Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect? =COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice",…
-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…
-
Formula to check for duplicate values across six columns
I'm trying to create a formula to check for duplicate values across six columns. I have a formula that shows if columns 2-6 contain a duplicate of column 1. However, I need to check if columns 2 & 3 are duplicated, and so on and so forth. How can I modify the formula below to do this? Thanks! =CONTAINS([Field of Study…
-
What formula to use to add $ and comma in the field
I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers? Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data? Thank you
-
Identify Duplicate Values On Select Dropdown Selections
I want to identify any new rows that are trying to use the same filename as an existing row. We do have reuses, so I do not want those flagged. I was able to set up a checkbox helper column for Duplicates that identifies any filename that is repeated in that column. =IF(COUNTIF([Filename]:[Filename], [Filename]21) > 1, 1,…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
