-
Can I auto add new users to a specific Workspace and access to the underlying sheets
There are a number of posts about this but they're several years old and answering my specific question
-
Average / Collect referencing another sheet and a date range
I'm trying to average the ticket ages for the current month. I’ve tried several formulas and currently I’m trying this: =IFERROR(AVG(COLLECT({SourceEOMCaseAge}, {SourceIncludeEOM}, "Yes", {SourceClosedMonth}, "April", {SourceClosedYear}, "2024")), "") The formula needs to include ticket ages where the closed date is blank,…
-
Task over due 3 days
How to make it to send an alert when the status is waiting on... and the task due date is over due by 3 days and it alerts the owner. It will only alert On the 3rd day and not all the days between the due date and 3 days past. Then an alert so that it notifies if it is 10 days in the past. The alert will only go out on the…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
-
Agregar el País PARAGUAY
Agregar la moneda de Paraguay: Gs (Guaraníes) - Y agregar el numero de teléfono de Paraguay, para parametrizar los formularios. (+595) Paraguay Paraguay
-
Hello! How can I work an OR statement into this formula? I need it to look at 6 different columns.
=IFERROR(INDEX(COLLECT({Provider being reviewed}, {MRN 1}, CONTAINS(@cell, MRN@row)), 1), "")
-
Change Cell Value workflow: Include symbols
Use case: When a new project is created, we want the initial project health to be a green symbol. The Change Cell Value workflow does not include Symbol type columns, only text/number, single select drop downs, and checkbox columns. Can we include Symbol columns in this workflow as an enhancement?
-
Inlclude predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
-
MAX COLLECT for blank cells
Hello all, we use a Smartsheet form for students in our internship program to submit their weekly hours worked for our instructors to track. Because the form creates a new row for each submission, I created a rollup sheet using MAX(COLLECT() to show all submissions on a single row to make it easier for our instructors.…
-
Select if multiple update request are acceptable.
Why not have a selection for multiple update request OK? We have sheets that get updated when information becomes available. But once you use the link and submit button for Update Request, you can not use it again. Our teams would like to use the Open request and submit multiple times for updates when they come available.