-
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.
-
COUNTIFS Help
I'm trying to use this formula, but am getting an error and I'm not sure what I'm doing wrong. =COUNTIFS({ElevationEscalation RCA Triage::[Triage Created]}, ">=" &TODAY(),{Elevation Escalation RCA Triage::[Triage Created]}, "<="& TODAY() + 5,{Elevation Escalation RCA Triage::[Intake Source]},"Intake/Elevation - Low") I'm…
-
Copy Cell Data from One Sheet to Another Based on Matching Values
Hi, I have two sheets that I am working with. One sheet has a URL that I want to copy over to the other sheet. Both sheets have an identifier column titled "Org Unit ID". I have trying to write a formula that checks both sheets for a matching Org Unit ID and then copies the URL from sheet 1 (titled "Concourse_URL List")…
-
Workflow - Generate Document - New Row Added from a Form
My workflow is as follows: When a new row is added (via form submission) and the "Type" field is a specific selection, e.g. "Business Operations", generate the document "SSV_Business Operations". See screenshot. However, the form is not being generated. What am I missing??
-
Formula: Which User Last Modified: Column 1 row 2
Hi, Is there a way to show who modified a cell, using a formula? I don't wan't to know who modified the row, i want to know in column 1 row 2, which user last modified that cell.. Thank you!
-
Using IF OR MATCH to Check for Value in Multiple Sheets
Hi, I am trying to write a formula that will take a value from the sheet the formula is in and check for that value in other sheets. If the value is found in at least one other sheet, the formula should return "Y". If it is not found, it should return "N". This is my current attempt, but this just returns "N" for…
