-
How to incorporate an OR statement in a =COUNTIFS statement
Hi team - I have a formula that works for counting "errors" on from source data: =COUNTIFS({Agreements out for Approval (C H M L) Exempt}, 0, {(Source Data) BDO Exempt}, 0, {Agreements out for Approval (C H M) main row}, 1, {Agreements out for Approval (C H M) Created}, IFERROR(MONTH(@cell), 0) = 10, {Agreements out for…
-
Struggling to send automated approval requests to multiple contacts generated by formula
This is the formula in my Assignee Emails Column:=IF(Parent@row = 0, email@row, JOIN(CHILDREN(email@row), " ") + " " + email@row) Then I get the emails populated throughout the hierarchy in Project Assignees column: =IF(OR(COUNT(CHILDREN(ID@row)) > 20, COUNT(ANCESTORS(ID@row)) = 0), AssigneeEmails@row,…
-
SUMIFS between specific cells
Hi! I want to sum the values in a column only if the values are between cells 2 to 729 and only if "Nina Gallagher" is in the "Who" column I've gotten this far -- =SUMIFS([10/5/20]:[10/5/20], Who:Who, ="Nina Gallagher") When I try this, I get #INCORRECT ARGUMENT -- =SUMIFS([10/5/20]2:[10/5/20]729, Who:Who, ="Nina…
-
Add a column for todays date automation
Can I insert a column that will automatically update today's date? I want to use it to compare today's date and contract date and the number of days between the two.
-
Return Sundays Numbers as Friday
Pulling production numbers and am currently using the following formula to pull numbers from the previous day =SUMIFS({GF}, {Date}, TODAY(-1), {MN}, "344") GF = Good Footage being calculated Date = Date Submitted MN = Machine Number This formula works for Tuesday - Friday but come Monday morning I need to have the data…
-
Lookup and fill in information based on another sheet
I have a large database of about 600 records. I created another sheet that comes off our institution's learning mgmt system showing several columns of information. In my database, I would like to put a formula in that would fill in several of my columns information, based on what course numbers are chosen. Can someone help…
-
Recurring Date to Fall on Specific Day
Hi - I've set up two columns "Cadence" and "Launch Date". For the top row of my sheet, I've listed the start date of the month (i.e. November 2) under the Launch Date for formula purposes. From there, on another row, I have a task where it should be completed 3 weeks after the start date of the month, but fall on a Friday.…
-
If function for children rows
Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…
-
Calculating cumulative value on dates
Hi, I have a sheet with a product that i produce and i have two column "in process" and "moved to stock" date type. i want to see by graph the time that each product was in fabrication. for example: item A : in Process: 01 NOV 2020 Moved to stock: 18 NOV 2020 so basically, the item was in fabrication in WW45+ WW46 + WW47…
-
how to get sum of a column to include only certain date range
Please could someone help me with this? We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue? Basically, we use smartsheet for customers to place preorders of different products (approx 50 different…