-
#DATE EXPECTED
I have a column that displays the date from a reference in another sheet. However there is a different column on that the source sheet where a date can be entered and it should display that date if entered. I tried to error trap for blanks but I am still getting #DATE EXPECTED. Here is the formula for context.…
-
Referencing another Smartsheet when #NO MATCH is found
Hello, I've been struggling to find the appropriate formula and AI hasn't helped either. Here is some context as to what I'm trying to accomplish. In my "calculation worksheet" I have a table with Data Links setup. These all work as intended with no issues. The problem occurs because after an items has been marked…
-
Trying to build a helper column to identify duplicate values but the cell value returns "NO MATCH"
I am trying build a helper column which will be ticked if the value under the column PROP_CD has a duplicate. I am currently using this formula =IF(COUNTIFS([PROP_CD]:[PROP_CD], [PROP_CD]@row) > 1, 1, 0), but all the cells return error "NO MATCH" Would appreciate any help or insight…
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Does the cell history come over when a row is moved from one sheet to another
I have written an automation that moves content from one sheet to another when certain criteria are met. I thought the cell history came across with the row but when I click on "View Cell History" after it is moved, I only get the history for the move and nothing prior. Is this working as designed?
-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
Is the a formulas that counts cells? Sheet limit question
Hi, I was wondering if there a formula that can count the number of cells in a sheet? I'm trying to make sure we don't go over Smartsheet limits. Also do the sheet limits count all cells in a row or only those cell with information in them? Thank you Kim
-
Data entered on a Report doesn't trigger VLOOKUP based on the underlying Sheet cell contents, Why?
I have a VLOOKUP set up to pull a date from a cell on Sheet 1 to a cell on Sheet 2. The date will only populate on Sheet 2 if it is entered directly on Sheet 1. Filling in the same cell of a Report based on Sheet 1 does not populate the date to Sheet 2. I have instructed users to interact with the Report for ease of use…