-
Retrieving last month's value
Hi, I am trying to retrieve the previous months value based on a primary identifier. I can set up my smartsheet to either move past values to another sheet or leave them all on a sheet. The idea is when a user adds a new line item, with a primary identifier, the previous month's price can be automatically pulled into the…
-
Days since Submission if not complete
Hello all. I love that I can come to you for help. Eternally grateful! I tried to find this in other threads but could not get them to work for me. I'd like to count the number of calendar days since the date in "Date Submitted" if the checkbox in "Review Complete" has not been checked. Thank you very much.
-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
-
Error - #INCORRECT ARGUMENT SET
Hello, Could use some help on a formula please. I am wanting to pull the number of open complaints by month that are over 30 business days and labeled private label. For some reason I receive this error - #INCORRECT ARGUMENT SET My formula is below: =COUNTIFS({Test Range 2}, Month@row, {Test Range 2}, "Private Label",…
-
Subtract date from previous row
Hi, i need to subtract a date-time rows from consecutive row ID as a formula. example: Row ID: JA001, Row Date-time: 01/09/23 10:53 AM Row ID: JA002, Row Date-time: 01/09/23 10:49 AM can you help me? Regards
-
What could I be doing wrong in my formula
Hello, I'm trying to count how many "CAR" are "In Progress" for each month but I'm getting the "Incorrect Argument" notification. Can someone tell me what I'm doing wrong? Thanks! =COUNTIF({CAR Log Range 1}, "In Progress", {CAR Log Range 2}, "CAR", {CAR Log Range 4}, IFERROR(MONTH(@cell), 0) = 6)
-
Issue creating Summary fields for Q1-23, Q2-Q4-23
Dear Community, I am trying to create Summary fields in my Smartsheet project where I show the number of projects targeted to close in Q1-23 and for Q2-Q4-23. Here are the formulas I have created: Q1-23 =COUNTIFS({Project Portfolio Tracker Target Date}, OR(@cell > "2022/12/31", @cell < "2023/04/01")) Q2-Q4-23…
-
Join/Collect? Formula to record text in a row on if a box is checked on sheet one ...
I am trying to put a formula on Sheet 1 in Column 2 that references Sheet 2, column 2 (DBE)( checkbox) - if the box is checked on Sheet 2, The text from Column 1 (Vendor) will all populate with a comma between each on Column 2 on Sheet 1 SHEET 1 SHEET 2 Thank you! I'm stumped on this one!
-
If "At Risk" add to Risk Register Smartsheet
Is there a way in a project plan that if the "Risk" column meets a certain criteria then specific cells of that row are copied to another Smartsheet? What I'm trying to accomplish is to have a risk trigger and then it goes to another risk register/matrix sheet somewhere to be handled in a RAID format.
-
I need to do automation of a date change,
I need to do automation of a date change, Customer A ("Customer" Column) The set Value for customer A is 14 ( "Value" Column This could be set in another column manually ) ETD date set 31/01/23 ("ETD" Column ) entered manually Cut of Date ("Cut of Date" Column) 14/01/23 ( this date should be automated, EDT-Value=cut of…
