-
Wildcard workaround
Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
Merged: Collaborate without sheet view - Only attachments and comments
This discussion has been merged.
-
How To: Create Something Similar to Access Subforms
Good afternoon. I work at an enterprise level (10,000+ records per table/sheet), and am responsible for creating a Service Ticket system within Smartsheet. Previously, I accomplished this using Access' powerful Form/Subform datasheet systems with custom forms and conditional queries, but I am now required to use Smartsheet…
-
Auto populate cell based on contents in two other cells in the same sheet
Hello - I've created a intake form to populate a sheet senior management will use for their assigned markets. Management has requested a link in the sheet to a report based on the contents in "Action Plan" (Yes) and "Market" (dropdown with 40+ city names). The manager would use the link to view the report without having to…
-
Calculating Average Submissions Per Day Formula
I cannot figure out what formula to use, and what rows to use in order to calculate how many submissions a day I receive on my sheet. Does anyone have examples of how they've calculated. I have the following date-related columns: Created Date Due Date Date Completed Days to Complete (a formula using the due date & date…
-
Help with IF AND formula with cross sheet reference
I am trying to write a cross sheet formula, and I keep getting an #INVALID OPERATION error, and I cannot puzzle it out. My current formula: =IF(AND({Scenario REQ ID} = [REQ ID]@row, {Scenario Status} = "Pass"), 1, 0) If the REQ ID from my scenario sheet matches the REQ ID of this row, AND the Status on the scenario sheet…
-
Adding a New Sheet to an Existing Summary Report
Hi there, I have a workspace tracking our grant applications using the Multiple Projects template. Each grant has it's own sheet for tracking the application process, implementation and reporting. The "Report - At Risk" and "Report - In Progress" reports are only pulling data from the original sheet I created. I've tried…
-
Cross Sheet Reference stopped working
We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company. I have a specific sheet…
-
Roll Up Calculation using separate sheet
I started with a template, but our resource management is a bit more complex than the template, so I am making adjustments to accommodate for our roadmap requirements. Of course this meant digging into the calculations. The template uses two sheets, PTO & Project Staffing + Staff Resource Rollup. The Staff Resource Rollup…
-
Nonsense letters - Mapping PDF doesn't pull information from form/sheet correctly
I am trying to use the entries from a form to auto-generate certificates of completion. It seems I have everything set up correctly (Fillable PDF mapped, set up in the workflow, correct column naming etc), however it generates nonsense letters for the entries. Any ideas on what I should troubleshoot to fix this?