-
How to Format Salesforce Date in Smartsheet for 30-Day Archiving Automation
Hi there, I have a sheet that pulls in Department Events via Data Shuttle from Salesforce. The issue is that I want events to archive off the sheet after 30 days. However, the date format coming in looks like this: 2026-03-16T00:00:00. Smartsheet automation doesn’t recognize this format. I tried creating a helper column to…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
I'd love to have a second row of headers
I don't even need them to be all that functional. Just be able to group Columns, allow me to open/close the entire group, and be able to use it in curly brackets to bring the entire group at once into a notification. Sorta like Parent rows, but for columns. It not only helps with speed of development, but also in the…
-
Sorting Activity log by Client Name / Internal Organization
When I access the activity log - it shows everyone who has accessed Smart Sheet in a specific Timeframe. Is there a way to filter to only show people who have accessed it that are in my Internal Organization? I tried using the collaborator field but it only lets me put in my email. When I put in other team members email…
-
Export Cell and Row History
It would be great to be able to export the activity log for a single row or a single cell. Right now, the export of the activity log does not allow for easy filtering to a single row or a single cell within a sheet, and is limited to 90 days at a time. We document our project portfolio with each project as a single row, so…
-
Timeline Integration from Smart Sheet Report - Bug?
Has anyone had issues using the timeline feature built off from a grouped report? Having issues with viewability and when I edit things look how I would expect but after saving many of the timeline views are blank. GIF attached shows how it is currently functioning and how the view changes when in edit mode vs. not.…
-
View Only account
Hi, I have paid my monthly fee and annual few but i still get a view only error
-
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
-
1 master report linked to multiple other reports
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…
-
Merged: Allowing the Lag days in the predecessor field to be elapsed days
This discussion has been merged.