-
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
-
Help with COUNTIFS, two criteria from the same column
I am being dim I am sure, I need to count some information that has been imported from an excel spreadsheet which is a download from our membership database so the formating is odd. This will be a regular download and upload so I don't want to spend time tidying things up so hive mind. This below works fine but I also need…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Formula for calculation
Hi Guys, I'm stuck with one critical problem, where I need one formula. I have two sheets Sheet A (contains only applied leaves, not all the dates range) Column 1 - Leave Start Date, eg 01 jan 24 Column 2 - Leave End date, eg 03 jan 24 Column 3 - Employee code, eg ABC001 Sheet B (contains entire range of dates for…
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
-
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…
-
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable! Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow! Here’s what’s…
-
Formula Assistance for Returning a Due Date
Hello, I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error. Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type. If the flag is not marked, I want the formula to…
-
Average value between two dates.
Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate the average TAT taken to complete a task in the month of Feb. I am not able to put two…
-
Is there a way to use Automation to update a Duration column?
I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?
