-
Tying parent tasks to children in reports
As far as I can tell this hasn't been brought up recently - hoping there may be new information available. I'm trying to build a report that pulls in tasks by current user, so that the viewer sees only those tasks that apply to him/her pulled in from multiple sheets. The challenge is that I also want the parent/grandparent…
-
SUMIFS Multi Criteria Function
I'm trying to sum a total using two criteria and it won't work. I can do the sumif for each criteria seperately but when I try to do the "ifs" one to combine the criteria it says "unparseable". I have these fields in one sheet and trying to sum them in a separate sheet: Month/Year Manager (as a Contact field but I don't…
-
PLEASE HELP WITH TURN AROUND TIME DATE FUNCTION, THANK YOU IN ADVANCE
I am nowhere near a Smartsheet Whiz. We have a column on our main sheet titled Create Date which we input. This is the date a work order was created. I am wanting to have another column titled TAT (turn around time) which will look at the Create Date entered and reflect how many days the ticket is open and continue to tick…
-
Date Conditional Formatting
Hi- Can someone please assist with how I can a conditional format setup for the below, or does this need to be a formula? Use case below: Column Services Date is a date I enter - I would like the entire row to turn yellow if it is has been 15 days from Column Services Date, and to turn entire row red if 20 days since…
-
If Statement on Expiration Dates
My criteria are the following If the Expiration Date Column cell is blank or greater than today+31 days = “Yes” If the Expiration Date Column cell is within 30 days = “Hold” IF the Expiration Date Column cell = today or greater than the date in the cell = “No” I tried using ISDate, Index Match, Date Only and it's not…
-
Highest value on the last six values of data
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
-
Forms - Formatting
Hello, I thought I had seen a video that had a snippit about how to format a form to show multiple fields on a single line. For example, when you have a start date and end date, I'd like both those fields to be on a single line instead of one below the other. My form has quite a few fields (even with using logic to only…
-
Adding Columns with Dates
Trying to add up two different columns- I think I got the first figured out, it would be a sum of all charge offs w/in a certain quarter this was my formula: =SUM(COUNTIFS({Credit Card Charge Offs Range 1}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020)), (COUNTIFS({Credit Card Charge Offs Range 1},…
-
Combining IF(AND statements with Dates
Hi - I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails. First date…
-
How do I set a formula for an entire single select drop down column?
I am pretty new to using SmartSheets and I've just figured out how to use formulas! I've been searching everywhere but I can't seem to figure out how to set a formula for an entire column. I want the formula to be automatically be applied when a new row is added (these rows are brought in via responses to a form). This…
