-
Formula Help Within Sheet
Alright, SmartSheet community. You've always been good to me with helping out. I've got a real "stumper" here. Let's say I have six columns on my sheet (in reality there's many, many more; but these are the ones relevant to my question): Start Date (a Date/Time column type) End Date (a Date/Time column type) Allocation %…
-
How to reference Summary Sheet field in Report Filter
I have a Sheet Summary Field that I want to use as part of the filter criteria in a report. How to I reference it in the filter? Alternatively, how can I use the Sheet Summary field in formula on a different sheet (than the Sheet Summary Field is created on) to mimic the report filter.
-
How to do an IF, AND and Multiply scenario with multiple options
I am trying to do an IF, AND and Multiply scenario with multiple options. I still need to add the 3rd option, but wanted to figure out what I am doing wrong. I tested the first option, it worked. Adding the 2nd resulted in Unparsable.
-
IF AND NOT
Need help with some formulas Important Columns : Schedule Health, Status, Target Start Date, Target End Date Schedule Health will hold the formula - changing to RED GREEN and YELLOW Depending on formula Green : IF Today is < than Target Start Date, AND/OR Status = "Complete" Yellow = IF Today is >= Target Start Date, AND…
-
What formula to use for days remaining before due/start date?
Hello community, I am currently a little stuck trying to figure out what formula to use for the "days remaining before conference" column. I'd like to have a number there to know how many days are left before the 'start date' of the conference. Do I need to add a hidden TODAY column or automation? I'm still fairly new to…
-
Count + Contains formula question
Hello! I'm having trouble with a formula in a sheet summary field. I have a column called "Service Type" where I want to count the number of entries that contain QA. There are multiple QA entries, some say QA+, some say QA5, QA10 or QA20, QA25, etc. to give you an idea. The common denominator is the QA, so I want to use it…
-
Progress Bar and/or Completion % by Check Box Column Status
Hello! I'm looking to use a formula that will calculate the percentage of tasks completed by row based on whether or not the check box is "checked." I have five check box columns, so if one is checked, the % Completed column shows 20%, if four are checked, 80%, etc. I know I need to use IF/And statements, but I keep…
-
Need a formula to recognize a checkbox and match it to a name
I work in a property mgt department and we've built a room inspection form. Our suites have rooms assignments based on the bedroom within the suite. The columns for the form are broken into sections of columns but I have the rooms assignment rosters broken down into rows. I need a formula that will recognize the box is…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…