-
Most of my Smartsheet Workflows are being disabled and I am baffled as to why
For the past 24 hours or so, I've been battling a phenomenon with my Jira Workflows where a majority of them are being disabled with a message: "The column mapping for this workflow is invalid. Please edit the workflow to fix the issue." I had not made changes to many / most of them in a few days, so it's unclear to me as…
-
Formula to add Months to Date
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
-
SUMIFS Formula, Criterion change based on row
I am working on an attendance tracker that counts the points "Occurrence" someone "Employee Name" gets for missing work in a rolling 12 month span "Rolling 12 Months?". I am attempting to use a SUMIFS formula to create a running total "YTD" of the points someone has accumilated, using the criteria of their name, in the…
-
How to pull one column of data from one sheet to another and be placed in the corresponding box?
Hello, I have one sheet where information is collected for candidates we are looking to hire, and I need a specific column from another sheet of information to feed over to the candidate sheet in the column. The results that are fed over, must align with the correct candidate. Pictures below for reference. I tried…
-
OTIF
I am trying to calculate OTIF per month. I just added a Helper Column to identify Ontime and Late items. For example, would like to know Aug. 2025 On Time vs Sept. 2025 On Time. How can I achieve this?
-
Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…
-
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
-
Requirement Document and Auto-numbering
Hi all, I'm trying to solve for a few things with a Business Requirements sheet. Auto-numbering of High Level and Detailed Requirements Association of High Level Requirements to Detailed Requirements Adds, Deletes, Changes. Example - A Detailed Requirement could be moved from one High Level Requirement to another. Example:…
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…