-
Employee Main List Formula Modification
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account…
-
Countif based on array of values
Hello, I hope this is possible!🤣 I have this list of states where a "Task Name" can have multiple sub-states listed on "Column 1" I've already "merged" the sub-states. Example below with Blocker --> "Test Blocked" & "Blocked" =JOIN(COLLECT([Column 1]82:[Column 1]89, [Task Name]82:[Task Name]89, [Column 4]86), " ") and now…
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({program Intake Form Range 1}, MATCH([Project #]#, {program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {program Intake Form Range 2}, 5,…
-
What formula do I use to calculate the number of years from a date till today?
=([Roof Install Date]@row - TODAY ()) / 365 I want this to be automatically calculated, but the formula posted on another post does not work. Please let me know how I can accomplish this. Thank you!
-
How to remove #Divide By when result is 0
This is my formula and the result is zero which is accurate, however the cell is displaying #DIVIDE BY. How can I change it to show 0% vs the error? =([Metric 1]@row / Totals@row)
-
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…