-
Countifs calculation giving wrong number
I'm trying to make a grid that counts how many tickets were open on any given date. In my grid I have a column for the dates I want to put in and then columns for how many tickets were open on that specific date. The formula I'm using to calculate open tickets on that date is: =COUNTIFS({Ticket List - Created}, <Date@row,…
-
Moved: Multi-Tier CC Provisioning Issue
This discussion has been moved.
-
Automation won't send again
Hello! I'm at my wits end and can't figure out why this won't work - the automation is intended to send an email out on the date in the Notification Date column (which is always a Monday) and to send it to contacts in three columns - Agenda, Review Transcript/Follow Up Items, Others to Notify. See below for how I have it…
-
Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row? An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.) Can I build something so she can create a row per patient with their ID…
-
Project Management - How do I create a recurring task within a project task list?
I have recurring meetings as part of my project and recurring tasks that need to repeat every week or month. How do I build that into a task list? For example, once the week 1 meeting or task is marked complete, I want to have it automatically repopulate with a new due date for week 2. I do this all the time in other…
-
Invalid Value on Index Collect
=IFERROR(INDEX(COLLECT({Checkbox Type Column "ID Finalized" on Smartsheet A}, {Text/Number Type Column "Reference" on Smartsheet A}, [Text/Number Column "ID" in Smartsheet B]@row), 1),"") The column for {Text/Number Type Column on Smartsheet A} called "Reference" could contain an ID like T1234 or a url https://abc.com…
-
Reports - When exported to PDF
When a report with groups columns exported to PDF, PDF doesn't show the report with grouped columns. It just shows a list of rows. How do I get the report what it displayed in the PDF? Don't want screen grab like solutions. Exported PDF: As you can see Project Manager, Project Name and Project Health columns (Grouped) were…
-
check box within date range
Hi community im looking for a formula to automatically check boxes related to dates from a table containing a start date and a end date table 1 is the dates source: table 2 (boxes to be checked) i'm trying this formula but there is no response: =IF(COUNTIFS({Sherbrooke - Time Off Tracker name}, [Main Tech]@row, {Sherbrooke…
-
Copy Row Automation Restricted to Provisioned Sheets
When I use the Copy Row Automation function I am only given the option to copy to another sheet that has been created/provisioned from the templates via the Control Centre. As I only want to copy the rows to s different sheet for a specific Project is it possible to create a new sheet within the Project, i.e. not via…
-
INCORRECT ARGUMENT SET
This discussion was created from comments split from: If Match Check Box.
