-
Stumped: COUNTIF Formula for 4 criteria and 2 ranges.
Hello! This is my first time utilizing the Smartsheet Community 😊 I am trying to develop a report that highlights the number of requests across four different categories (RFPs, New Programs, Funding Rounds, and Rolling Applications) within four fiscal quarters. So ideally, I want a formula on my sheet summary to tell me:…
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
Smartsheet App - Sharing Workspaces and Sheets
When I share a sheet or workspace on the browser version of Smartsheet, I have the ability to check/uncheck notify people. I would like that same feature on the app. Currently there is no box to check or uncheck, it defaults to sending an email to the person I am sharing to. In my organization, we do not like to send…
-
Quick Form Toggle Accessibility from Sheet View
Capability to quickly access form from a sheet rather than clicking Forms, MANAGE FORMS, THEN OPEN FORM.
-
Card View for Sheets/Reports in WorkApps
Using a WorkApp to keep all high level sheets/reports/dashboards in one area. One of those is from the "Simple Request Intake & Tracking" sheet. Being able to use Card View on the Workapp would promote the use of Card View to be able to move tasks from "Not Started" to "In Progress", or move it from one "Assigned To" to…
-
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
Generate Document Text Customization
When generating documents, there is a preset text and text size. There are no options to customize. Often, the preset text does not match the text format on the document.
-
Merged: Date Format
This discussion has been merged.
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…