Hello, I am wondering if anyone in this group uses Smartsheet for Permit or Special Event applications? We are looking to utilize Smartsheet to streamline our Alcohol Permit process and I wanted to se…
Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added …
I think I've found a bug. I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column. DATE TEXT = Date + "" DATE TEXT is calculated by …
Hi community, I would like to multiplicate rows depending on the values of a multiselect field "Values". e.g.: 1) field multiselect "Values" can contain a, b, c 2) if a single value a, b or c is selec…
Does anyone else have a challenge with this mix of functionality? As a "free user" with admin access to a sheet, someone can move or copy entire rows somewhere else. But that same user cannot lock a r…
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking fo…
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to…
I am trying to pull data from one sheet into a summary sheet. Basically I am looking to pull if a given site met a target on a given day -- an admin is entering in the number of employees reporting fo…
Does anyone know a way to select all fields when using the "Alert someone" workflow? For "Send Rows" or "Update Request," there is an "All" that you can select to select all fields. In the "Alert some…
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respec…
