-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
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…
-
Customizable view options in Smartsheet Card View
I think it would be useful to be able to customize the Card view in Smartsheet grids and reports to include additional view options, such as by date or other custom columns, instead of being limited to the default options like "status", "schedule health", or only being able to view by columns that are dropdowns or symbols.…
-
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…
