-
How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company. They've not been able to provide the level of reporting my SLT is requesting. How can I create a dashboard from that project without doing any changes or calculations, summaries within their project? They did make me an…
-
#INVALID VALUE Error - Can't figure out why...
I am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH(Auto@row, Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amount: Text/number column =INDEX({Job Tracker Invoice Amount}, MATCH([Invoice Number]@row, {Job Tracker…
-
Formula to delete specific values from a multi select dropdown column
Hello. I have a COI Tracking sheet that tracks insurance by vendor, which includes a multi-select dropdown column that lists all of the job numbers that the vendor needs to supply insurance for. I have one column for Current Jobs, and a column for Expired Jobs. I have a secondary sheet called Closed Jobs that tracks…
-
Trying to count if data range falls between two dates.
I have a sheet with StartDate and EndDate fields. I want to count actual items opened on a separate sheet if the date falls between the start date and end date. The below formula keeps returning #UNPARSEABLE and I suspect its something minor. =COUNTIFS({Request Tracker with Form Range 1}, "<=" & (EndDate@row),{Request…
-
Autopopulating Dates Based on 2 Fields
I'm struggling. I have a workflow to auto-populate the created date. I have another column that determines the type and length of review requested (3 days, 6 days, or 12 days). I would like to auto-populate to a specific submission date Mondays at Noon to be discussed at a recurring meeting on Wednesdays, so it would be…
-
Custom Auto Number Formula
HI Community I need help creating a custom auto number formula using set prefex and a reference column. The DRN "number" or Identifier must populate as follows: ABCDE-DRN24-020T. The prefix 'ABCDE-DRN' is absolute for all numbers and the '24' after DRN is referencing the FY Reference column year. The next 3 numbers after…
-
How to apply cell formula to new rows added by form.
I have a cell formula to apply to the row 1.. I need new form entries added to top row to automatically apply. The form entries are the amount of dollars or change turned in to get total amounts by count. I can not make it a column formula. please advise. I tried using Absolute ($) but it changes row # with every new entry.
-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
What is the longest formula you've created?
As the title suggests, I am very curious to see how far some of you all have pushed the limits of Smartsheet formulas. I think it will be interesting to see everyone's longest formula, and what they created this formula for. I'll go first: A person on the Smartsheet community was requesting a column to have employees names…
-
Smartsheet users in The Netherlands
Hello, We're using Smartsheet in our R&D department to manage product development. In order for us to make a next step in using Smartsheet functionality and building more complex dashboards, we are looking for Smartsheet users in The Netherlands or Benelux. Please reach out to me if you are or know someone. Thanks, Rob