-
Requesting help reporting top three vendors for three locations based on a common review database
Our team is trying to build a tool to intake vendor reviews based on five averaged criteria to inform vendor selection on future projects. I've built the form, a review collection database, a review metrics helper sheet, a vendor masterlist and a preliminary report. I'd like to be able to consistently report the top three…
-
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…
-
Quick Form Toggle Accessibility from Sheet View
Capability to quickly access form from a sheet rather than clicking Forms, MANAGE FORMS, THEN OPEN FORM.
-
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…
-
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…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…