-
Help with checkbox formula
I am trying to make a checkbox on one sheet change depending on two criteria on a separate sheet. The first sheet has data showing drills submitted by location and date. My goal is to show completion on a monthly basis. ex: 10/12 sites completed drill in January I need the other sheet to show completion for each location…
-
If Status is one of two options, then checkbox is selected formula
I am trying to build a formula where if a status is either "Pending-Crim" or "Clear w/ Exceptions" then the checkbox will check, however I can't seem to get the formula to check the box once the status has been updated. Here is the formula I am using: =IF(COUNTIFS(Status:Status, "Clear w/ Exception", Status:Status,…
-
Drop Down Lists
I'm creating a list of pre-definded codes for a drop down list e.g. 1, 2, 3 However I'd like to indicate to the user with the aid of a pop up or note saying what 1, 2 or 3 actually means to ensure they enter the right value. Instead of simply entering 1, 2 or 3 I could put a word description in but I'd further like to…
-
SUMIFS not calculating values-giving result as "0"
Hi, I am using following SUMIFS, though it is not throwing any error but it is not calculating the values in required range: =SUMIFS({Deliverables}, {Engg}, Resource@row, {Completion Month}, Month@row, {Status}, Status@row) Can anyone please help me know know, where I am missing on writing the argument? Thank you, Prajna
-
Flagging a Date 30 days past due?
I have a sheet with the following columns: Last Updated: date in which a customer profile was last edited Next Review Due: a date calculated as 4 months after the Last Updated Date -- this is the time at which an account team should review the customer profile data to ensure that it is still up-to-date and if any changes…
-
Can I create automated survey feedback to a user in Smartsheet
I'm new to using Smartsheet and I'm trying to design a survey with automated feedback to the user. I'm wondering if Smartsheet has the capability to do this. Here is an overview of what I'm trying to do. I have created a survey that will be going to out to certain company branches. The survey has 10 sections with a pass/no…
-
if and blank
Hi, I have a date that a survey was completed and a date that someone has contacted a customer and I'm looking to create a formula that highlights if the response date was over 3 days ago AND there has not been a successful call (the contact date column will be blank) then mark this as red, if the response data was over 3…
-
Nested IF statements
Can anyone assist me in where I am going wrong? =IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row), IF(AND([GEAR.]@row = true, LTG@row = true) = true, [PROJECT TOTAL]@row)) If checkbox1 = true, set value to cell 1, if checkbox2 = true, set value to cell2, if BOTH checkboxes = true, set value to…
-
Add How Many Names Appear in Column Without Using A Formula Using a Specific Name
I need to track first aid statistics to determine how many employees are responsible for first aid incidents, per month, per location. We have 275 employees and any of those names can appear in the spreadsheet during the year so I don't want to create a formula that will contain that many names. I want to pull information…
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…