-
Collecting Duration a Row is on a Status
Hello, I am working on a sheet where we have several statuses that can go in just about any order. We have a suggested flow, but it's more to help the user read through and make sure they didn't miss anything. I've listed the statuses below for reference. For example, the user could go from 1 to 2 to 3 to 4c to 14 to 16.…
-
I Need to set up email automation,
I need to setup email notification for 'Assigned To' contact list with respect to Caldue date coloumn. Every time I try the emails gets sent in to all the contacts in assigned to. Help me out ASAP
-
How do I use 'or' with CountIF?
I'm getting all twisted up in what I believe should be a Countif formula. I basically want to populate: If the status is COMPLETE for Department A, B, or C I want that total. If that status is IN PROGRESS for Department A, B, or C I want that total. If that status is NOT STARTED for Department A, B, or C I want that total.…
-
Edit attachment from a sheet
Hello, Currently attachment is allowing either to attach a URL or upload a file or different file versions. But for editing, the user cannot edit online and it only allows to download the file and upload it again. Do you know if there is a plan in Smartsheet roadmap to enable a functionality for editing existing…
-
Report Not Showing Any Columns from Sheet
These are the column names from the sheet I am creating a report from... These are the options for columns that show up on the report... I am doing something wrong that is keeping the columns from displaying on the report? I have created several other, similar reports before and never had this problem.
-
How do I create a report that displays rows that are passed a certain set date for each row?
I'm attempting to create a report that easily displays rows that are delayed. For example, if I had a planned delivery date of 08/07/2024 (UK Format), but this was actually delivered on 10/07/2024 (UK Format), I would like the report to only display this row. If the planned delivery date of 08/07/2024 (UK Format) was met,…
-
Adding new columns in the roll-up where data comes from the control center to the roll-up
I want to add some extra columns to the roll-up sheet, but I'm afraid it will break the links in the roll-up.
-
Automatically update Unique names in a ranking sheet from a survey intake sheet
Hi All, I am currently building a system to rank speakers. I am try to copy unique names from the survey sheet to the ranking sheet so that I can sort them by some statistics. However, I am having trouble figuring out an automation that correctly identifies the unique names in the survey sheet and also updates the ranking…
-
Adding free-plan users to organization
I am confused about adding free users to the organization. I have a number of full licences, with a number of free accounts collaborating as guests. Some of them have been able to sign up for the free account and they appear in the organization; however, others do not appear in the organization. What could be the reason…
-
Issues with "Record a Date" Automation
Hi all, Any idea why this automation isn't recording a date? We have a formula that's designed to return a value of "Reorder" whenever the inventory for that products dips below a certain threshold. The formula is working, but it's not being recognized as a trigger with the attached automation. Any advice would be much…