-
Multiselect checkbox
Ok so here is the logic I'm working on right now. The formula for A, B, and C is the same all you have to do is swap out "A", with "B", and so on. =IF(CONTAINS("A", [Dropdown Test]1), 1, 0) What I'm trying to figure out is the formula for the A & B, B & C, and A & C. Meaning when I select A & B I want both flags for A & B…
-
How do you apply the =SUM(COUNTIFS(DECENDANTS()) functions with 3 or more criteria?
I am using the =SUM(COUNTIFS(DECENDANTS()) functions and have successfully applied it for 1 criteria set with the following.. =SUM(COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "Staff")) and also successfully applied it for 2 criteria set with the following...…
-
Creating an Age Pending report
I am fairly new to Smartsheet and trying to create an age pending report. I have used the =IF(Submitted By = 1, 0, (Created1 - TODAY())), and receiving an error message. Could someone assist me with this please?
-
Best Formula to use to COUNTIFS based on several criteria.
I'm trying to come up with a formula that will return a number based on several criteria. I have a separate sheet that I have a key of allotted days off for each area (Vacation, Personal, Summer Friday, and so on). On that separate sheet, I have an available days based on the Key, minus the formula that i'm trying to…
-
Can i remove multi-select from single cell?
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when employees work 1/2 a day and also 1/2-day Holiday or 1/2 day unpaid, on the same day.…
-
Using Date within formulas to calculate Harvey Balls with duo criteria
Hello, I am stuck on making the following formula work in my project plan. 1) Using the flag symbol, I am trying to calculate: IF the status = 'To Do' AND the date is today or in the past then FLAG otherwise no FLAG. I have a 'Status' column with the following values: To Do, In Progress, Done, Closed, On Hold I have a…
-
Summation of rows that have been inserted via Form
I would like to have the sum formula already in my sheet so that as voting takes place it automatically sums the total and displays in a report. I have everything set up. However when the data is inserted from the form (top or bottom) it places it above or below my formula. Is there a work around for this? Thank you
-
Countif depending on 1)string value 2)date range
Fault type Date raised Microbial 01/1/2020 Microbial 12/1/2020 Chemical 14/1/2020 Chemical 01/2/2020 Physical 01/3/2020 I have been successful in getting the count for the [fault type] through (e.g.'microbial') =COUNTIFS({Supplier Performance Range 1}, FIND("Microbial", @cell) > 0) But I would like to also do this by…
-
Trying to do a COUNTIF two columns fall under a certain criteria
I am trying to create a formula in my sheet summary that will provide the count for a completed project with a certain firm. I only want the formula to provide the count if it is both status green and analyst firm gartner. Status being the one column and analyst firm being the other. I keep getting the error: #UNPARESABLE.…
-
Days combined with Status formula
I am trying to calculate the number of days between 2 dates, my calcuation is working but I now need to update it to have it only calculate if the status is "Wrong Account" and I keep getting an error. =SUM(Date1 - [Invoice Date]1)