-
IF formula combined with dates
Hello, I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example: If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and if the date is between 04/01/2018 and 06/30/2018, then 2nd. Quarter, etc.... Thank you in advance!
-
Creating a technology device loaning process
Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time. I have been working on a loaning process…
-
Checkbox autochange status
In my sheet I would like the 'Status Level' column to autochange to 'Complete' when the checkbox for completed is checked off. Is there a formula to so this with?
-
Countifs Formula Help!
The current formula is: =COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too. Thoughts? Branden
-
Multiple If Statements
I'm having a difficult time making multiple 'If' statements work, cross sheets. I would like the sum of a column to be brought over to another sheet IF it meets the following criteria: 1. meets a corresponding category, and, 2. has a check box. The first half works (below), without the check box being checked: SUMIF({LGES…
-
Check boxes and formulas
Hello We are using Smartsheets to build ships.. but I have an issue with the formula(S) I want to be able to use a tick box for a formula.. We have many options priced and I want to use the tick box to generate option pricing. If the box is ticked then the price will move to the next column that is auto summed. If its not…
-
Count anything that is passed due excluding certain criteria
It is not supposed to count anything that is closed, lesson learned, or duplicate. The current formula is: =COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate. I am…
-
Conditional formatting of dates
I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
Counting Due This Week
I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?