-
Check Boxes and Cross-Sheet References
Hello Smartsheets Community! I have possibly a complicated question. I have two sheets, one is essentially a "job log" while the other is an "order sheet" with items for several different jobs. Is it possible to have one box on the job log be checked once all of the items for that job on the order sheet have been checked?…
-
Resource Management - Formula for various different schedules
Hi all, CC:@Genevieve P. I'm using smartsheet for resource management and the sheet links to our smartsheet resource tool. In RM smartsheet, we have different resources on different schedules e.g: Some work 7 hours a day Some work part time (4 hours a day) Some work 4 days a week at 8 hours and 7 hours (Fridays off) We…
-
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…
