-
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…
-
Is there an option to prioritize workflows?
Hi All, I have a folder with a few different sheets, one being my main sheet that my team works off of. This main sheet has a number of workflows for all the moving parts of our project that we track. As we move along further, I have realized the amount of workflows is starting to be a problem with prioritization. Say I…
-
Report columns from 2 sheets to appear side by side
I have a report that pulls several columns from two sheets. By default, the rows from 2nd sheet appear below the rows from 1st sheet. But I want the rows from 2nd sheet to appear to the right of the rows from the first sheet. Is this doable in Smartsheet? And, what if the number of columns I need both the sheets are not…
-
Display Most Recent Created Date AND Time
I created a simple check-in form whereby the system Created Date field is to be the entry time. It will be a running sheet where all punches are stored so, for reporting purposes, need to pull out only their most recent date/time for display - the 'time' piece being my challenge. (Also have "Check-in / Arrival" criteria…
-
Trouble with Chrome Base web interface, no horizontal scroll
Hello - Is anyone else experiencing this? We have several google "chrome base" desktops, (just like a chrome book laptop, only a desktop).....while working from with in the chrome web browser, on the chrome base, we are not able to use the horizontal scroll in the grid view. We have to resort to selecting a cell, and using…
-
UpdateRequest: Question
When I "request an update" to a row, I need the project name (in one of the columns) to show up. However, the project name is not in the same row as the one that needs updating as its a table format. Is there anyway to get the project name to show up without directly copy and pasting the project name in the row I need the…
