-
Date Formulas
Hello Everyone, I'm new to the smartsheet community, but have been using smartsheet at a basic level for a few years now, and I am looking for some help. I have a form that collects information for me. Each time the form is completed and submitted it creates a new row in my sheet. In my sheet, I have a column called an…
-
Filter for Column Type "Date" only functions on the Sheet and not Report
I have a column in a Sheet that contains dates. This is the source data for a shared Report. I would like the report to filter only rows where this date column is blank, however if I make the column type to Date, the filter condition "is blank" only functions as expected on the Sheet and not the Report. The Sheet correctly…
-
Cross references automated
Objective: I am attempting to establish an automated process in Smartsheet where values from a "Date" column in a "Source" sheet are accurately copied over to a "Target" sheet. This aims to ensure that when new rows are added to the "Source" sheet, the values in the specific column are instantly replicated in the "Target"…
-
How to autopopulate cell based on date in another cell
Hello! I am trying to automate adding an ID in my sheet for "2023Q4" and then of course next year for 2024Q1, etc. Currently, I am adding the ID manually and am wondering if there is a way to create a formula that will tell me IF the submission date is between the dates of a particular quarter, the ID updates to the…
-
I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?
-
SUM range of cells that have INVALID DATA TYPE
Hello, I am trying to sum the range of cells, and some of them have INVALID DATA TYPE. I have tried the original formula here: =SUM([Actual Days to Reach Milestone]74:[Actual Days to Reach Milestone]83) And I tried adding IFERROR, but my answer just says 0 instead of counting the cells the that have the error as 0. The…
-
Adding IFERROR to functioning formula and getting INVALID DATA TYPE
Hello, I currently have this formula and it works perfectly: =IFERROR(NETWORKDAYS([PCD Draft 1 Start Date]@row, [Completed Date]@row, {Holidays}), "") I need to include in this formula two columns for projects that are on hold (internal hold and external hold). Those columns have a formula in them looking at the…
-
Column has a formula, need answer as a multiplier
C Value column is a formula =IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31…
-
Copy part of a code within a cell
Hello community! I'm looking for a formula or workaround for capturing part of a code in a cell and copying it from another cell In my contract number column I have 91B023047 I would like to copy B023 to another cell by somehow removing 91 and 047. Is this possible somehow?
-
Convert to Colum Formula on new duration column
Hi! Playing around with the new duration column on calculating days between two dates. I am unable to convert to column formula. I can see that you need absolute reference which I believe I had. Hoping someone could point me in the right direction, please and thank you. If I use this formula I get the right answer =([End…
