-
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,
-
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".
-
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
-
SUM Providing Wrong Number
This discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum).
-
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.
-
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,…
-
Building Vendor profiles and establishing master vendor name for match/index
We manage a lot of vendor information in Smartsheet for various projects. We are working on building a master list of outcomes for a client and the vendor name can vary project to project. As an example, one project may say, ABC Corp and another will list the same vendor as ABC Corporation. We want to analyze the outcomes…
-
SUMIFS Across Two Sheets with Multiple Criterion
Hi All, I am looking for a the next step of this formula, I now want to include a department filter on this SUM Formula instead of all departments? is that possible =SUMIF({Timesheet Range 1}, =[Export Title]@row, {Timesheet Range 4}). Timesheet Range 1= Phase Name - Sheet 1 Export Title= Phase Name - Sheet 2 Timesheet…
-
Proper Syntax for IF and VLOOKUP
I am trying to create a formula that will run VLOOKUP if a cell is blank This doesn't error but it leaves the formula field blank =IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))
-
Reference Another Sheet without Function
We use "Reference Another Sheet" quite a bit in our sheets. We do this by starting a function in a cell, then putting an open parenthesis, then clicking on the link in the resulting dialog box that reads "Reference Another Sheet" . This works fine. The thing I'm running into is sometimes I want to reference another sheet…