I have a sheet that notifies people when they need to review a document based on when it reaches its expiration date. The idea is that people are sent an email notification 90 days, 60/30, and 7 days …
Hello, When creating Documents in Smartsheet or capturing data through Forms, Smartsheet currently processes dates in the background in the US in American format. Ideally, once processed, the output i…
I'm hoping someone can help. I've used Smartsheet for years (at another company) and have never ran across this. I'm trying to record a date when the status changes to "1st Review". I have even gone s…
If you set a final date (24.11.21) and entered a few days over a period of time, you must check the date backwards (24.09.22). Currently, only dates with additional time are displayed (25.02.12).
Hello! I have a sumifs formula that works great: =SUMIFS({Amount}, {Branch Number}, Label@row, {Request Type}, "Maintenance") My problem is when I try to add a date aspect to this formula. I want to b…
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. Th…
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted i…
Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered …
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projec…
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but…