-
Subtract six months from a date
Hi, I have been reading the community but am confused. I have a date that updates a few times a year, let call that column A. I need column B to give the date six month prior to that date. So I need to subtract six month for what in column A. Can someone please give me some advice to do that. Thank you Kim
-
Two part formula question.
I am trying to count the numbers of cells that have a checked box and have a date within two cells for a training tracking sheet. I am trying to track who has completed assigned training only. I don't want to count the date if it wasn't required. I would like to do it for each row (each employee) and for each column (each…
-
Countif for multiple columns
I am trying to count a score for multiple columns in a smartsheet summary. For some reason, it is only counting the first column if I use this: =COUNTIF([Educational Background]:[Educational Background], COUNTIF([Prior Work Experience]:[Prior Work Experience]) = 5) If I put the extra ) at the end, it makes it unparseable.…
-
How do I bring over select fields from Sheet A to Sheet B if Sheet A's submitted date is today.
Hey Smartsheet, I have two Sheets and am trying to bring over Staffing Level, Collections Scheduled and Collections Absent from Sheet A to Sheet B if the submission was today for matching Departments. (Incases of multiple entries I want to bring over only the latest submission) I've tried Max/Collect with Today formulas…
-
Using nested MATCH/INDEX across multiple columns
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…
-
Can an error message generated by a formula be used to trigger a workflow?
I've seen suggestions in other forum posts that this does not work, but nothing conclusive. I have an index/match formula to link data from sheet 1 to sheet 2. If the indexed row in sheet 1 is later deleted (the project is cancelled, for instance) there is no longer a match and I get a #NO MATCH error in sheet 2. I want to…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…
-
CountIFS for Parent Row Only
Hello - I am displaying some information regarding things that are approved, in queue or denied. But I am needing to only count parent rows and not the children for them. So the data collected are just for the overall brand and not sub-brands. Is there a way for me to make this happen? Thank you - Mmurray
-
index match crossheet
i have sheet A that will look at sheets Q1,Q2,Q3,Q4 TO CONFIRM IF THERE IS A MATCH. and if not to return no match =IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022…
-
Formula to count issues raised this quarter and in previous quarter
I am putting together a metric sheet that will count issues raised based on various dates. I already have it set up to count this month vs last month, but I need help doing the same for quarter. In my main data set I have added a helper column to return the quarter based on the date an issue was flagged. How can I use this…
