-
Updating Previous and Latest checkboxes based on a value in another column.
Hi & Happy Friday, I'm putting together a status reporting sheet and I need to be able to update the previous and latest rows, based on a separate column, in this case the Submission Status column. Formula in the Previous column is: =IF(([HC-Row ID]@row + 1) = MAX([HC-Row ID]:[HC-Row ID]), 1) Formula in the Latest column…
-
Index Match Returning Unexpected Value
I feel like I've posted 1000 Index Match questions this year! I have a formula (below) that is returning and individual who has the same Date Assigned field but not that same MLL ID. The MLL ID is supposed to be the thing that stops the date range from looking at all the cells. I'm trying to get Ciara as a returned value…
-
All Cross Sheet Reference has been deleted automatically from Smartsheet
Dear Smart Team. Suddenly all Cross Sheet Reference has been deleted automatically from Smartsheet which impact all business users. Even in the logs is not showing any activities. How Can i rectify and fix this issue. Is there any way to retrieve all references without re-creating again. Please note that yellow highlighted…
-
Update a date using a daily automation
Hi community, i'm looking to use either a formula or automation to update a target date at the completion of each day. Basic workflow is to add a single day to the target date for all tasks that are incomplete. In this content we use target dates as a sorting tool and they are not necessarily firm due dates as such.…
-
What is the formula to determine the number of months that overlap between two date ranges?
I need help getting a formula to work for figuring out how many months are overlapping for project with a start and end date within a fiscal year start and end date. Here is the formula that I am attempting to use. Please help!!! =IF(AND([End Date Planned]@row >= [FY25Start Date]@row, [Start Date Planned]@row <=[FY25 End…
-
Using IF/THEN for my formula
Hello, I recently received advice on here to develop a formula that lists out all projects that individuals are billing to via cross sheet formulas. The below formula would go into the Projects column in the Enterprise Rollup. =JOIN(COLLECT({Project CHEAT}, {Person}, Person@row), ", ") This formula works, however, it is…
-
Return a value based on the date and section
Hi, I'm trying to create a sheet for a department production report, This department has 10 sections, each section do different type job but the project is same, i'm keeping all section work in a mastersheet so that i can filter however i want to generate a report. the Problem i'm facing is the closing stock should be…
-
Formula to Obtain Cumulative Month Total From Previous Days
Currently I am using a formula that will give a month to date sum from previous days. It was working until I got to a new month. The formula is =IF([Medicare Calls Received]@row = "", "", SUMIFS([Medicare Calls Received]:[Medicare Calls Received], [Date of Service]:[Date of Service], <=[Date of Service]@row)) What I am…
-
#INVALID OPERATION Caused By Data Import Adding an Apostrophe
I have a Nintex Automation Workflow set up in which users fill in a form with numerical data and submit it - the form is basically an end of day inventory count. The form pre-fills all fields to 0s, and users can change the totals if there is more than 0 of any item. Smartsheet doesn't like data importing with blank cells…
-
Sum data and not change data after certain date.
I am trying to sum data as of XX/XX/XXXX of each week. I want this data then to go into a cell and not be changed the next week. For example, on 1/15/24, a sum formula was used to calculate the number hours remaining was 3891. On 1/22/24, the sum formula was used to calculate the number of hours remaining as 3201. Is there…