-
Auto check box using =IF(Primary@row="California",1,0)
This formula works as typed. However, I need your help writing this formula such that it will auto check box if the word is "California", or "Florida", or "Arizona".
-
I have four cells that require approval, I want to create a formula
I have four cells that require approval, I want to create a formula that says if all four cells are blank then the cell for approval status is red. If all four cells are not blank then "Green" for approved. I am a novice user and any help would be greatly appreciated. Thanks,
-
Duplicating sheets deleting certain columns and team distribution via viewer mode
All, Thank you for your time. I am trying to accomplish a few things simultaneously: I have a master account sheet that I want to send out to the rest of my team but I want to do it in the following way: Send them a duplicate sheet with certain financial columns omitted As I update the master sheet, the sheet that is sent…
-
Sumif formula problem
Hi, I'm trying to modify this formula: =SUMIFS({Total Sq Ft Scanned}, {Field Status}, "Completed", {Field Work Completed Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2021)) The Field Status column is a drop-down. I want it to sum up every status EXCEPT completed (other stutuses are In progress,…
-
IF(OR (ISBLANK)... HELP
So I want a box to check IF any of the green boxes below are blank. This isn't working... just trying to use 2 of the boxes. =IF(OR(ISBLANK([1421 COATING WEIGHTS]@row), (ISBLANK([1310 CTG WEIGHT 1]@row), 1, 0)
-
Count Formula for At-Risk
Hello, Im trying to count all the At-Risk items for a specific team in the sheet summary. I have a Status column and a Team Owner column. Ideally, I would like to know what the formula would be for capturing the number of items At-risk for a specific team.
-
Reference Multiple Columns from Another Sheet
I'd like a way or formula to pull 9 columns from one sheet and display into another. Cell Linking is not an option as new rows are added daily to the original sheet
-
How do I do a min/max output based upon a specific criteria?
So I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of days that specific jobs have been open and working within several different groups in my organization. Each organization…
-
Can Smartsheet fill an email template?
I have an email template that I fill manually with cell data before sending to a client for billing. Is there a way that Smartsheet can automatically fill the appropriate information into the email template?
-
Set RAG based on % Complete & Deadline Date Proximity
Hi I am trying to get my formula to set a RAG status based on the % complete and deadline date proximity. My formula is: However, the last entry with a deadline date of 12/11 show be showing a "Yellow" RAG but, it still shows "Red". What have I missed? TIA Cheryl
