-
Formula across multi Workspaces
I am trying to create a formula that encompasses many different areas across numerous workspaces. I need to be able to calculate the percentage of complete tasks within a milestone across 6 different workspaces. I know I am missing a key element to allow the formula to work but after playing around for 2 days I still can't…
-
IFERROR and MATCH
Hello, I am trying to say: **On 2024 Conferences Sheet** If project name on sheet "PO List Service and HR" matches the conference name on "2024 Conferences", input the PO number from "PO List Service and HR". This is currently what I have: =IFERROR({PO list service and HR Range 1}, MATCH([Conference Name]@row, {PO list…
-
Formula
I am looking for a formula that would allow me to take the number value of 1 cell and multiply it by the number value of another. In this case it would be Quantity x Price per unit, and have the result populate on another cell that I have labeled "Total Costs". I know this is a simple fix, please help?
-
Sum only open orders with "Open" status.
It is possible for POs to have several different part numbers on it, as well as the same part number be on multiple POs. It is also possible for POs to be partially complete, therefore, each line item has its own status. I am wanting to get the total number of each part needed to put on the schedule. The issue I am running…
-
Formula based on criteria?
I have no idea if this is possible, it seems like it should be. I want to calculate the difference between two cells, but only when both cells have values, otherwise the cell should remain blank. So if "January Spending" has a value (Cell B), then it should be subtracted from the "Estimated Monthly Spending" (Cell A) -…
-
Help with reporting between 2 dates
Hi, I am having issues with working out how to get a total count on dates 1st to count how many of those tasks were updated under 7 days. =COUNTIFS({person1}, [Person1]@row, {Date updated}, <=TODAY(7)) 2nd to count how many where done between 7 days and under 14 day =COUNTIFS({Person1}, [Person1]@row, {Date updated},…
-
Ideas for adding a column for notes on a report that won't transfer back to the sheet
I am building a report and the leadership would like to add their own comments, however they do not want it transferred back to the sheet. Option -add a hidden column on the sheets for them to add their notes-however if someone decides to unhide everything they will see it. Thoughts or ideas?
-
Duration Formula
Hello, Trying to recreate a formula i wrote in a previous role to track duration for a monthly average. My formula is written as so: =IFERROR(SUMIFS({Duration}, {Duration}, ISNUMBER(@cell), {End}, ISDATE(@cell), {End}, (IFERROR(MONTH(@cell), 0) = 1), {End}, (IFERROR(YEAR(@cell), 0) = 2024)) / COUNTIFS({Duration},…
-
Change Text/Number to valid date
I'm using a date in the primary column, of course Smartsheet sees this as just text/number. I've added a column called "Date" and want to convert the Text/Number to an actual date. Primary Column...........Date 1/29/2024....................01/29/24
-
Question on Metric Sheets and COUNTIFS formula
Hello! I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did! Here is my formula: =COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2) And here is my table: