-
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…
-
Assist in Auto-Numbering
Hi, I cannot get my auto-number to work properly. The [Type of Book] can equal TB, BB, RB, or USB. I have used a similar formula before but I cannot get this one to auto-number like the others have and I am usnure what I have done incorrectly. Thank you for any help. =IF(AND(COUNTIFS([Row ID]:[Row ID], <[Row ID]@row, [Type…
-
PDF Report
Hello - I needed to use emjoi for status indicator because we needed more options that were provided in the symbols options. However, when I PDF a report, the status icons are not showing. Is there a way around this? First image is the report, second image is the PDF of the report.
