-
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
-
Status Update Formula
Hi team, I have lost one of my most favorite formulas as a project manager. Here's what I'm trying to accomplish: If % Complete is 100% - select "Complete" for the status column. If % Complete is between 1-99% - select "In Progress" for the status column. If % Complete is 0% - select "Not Started" for the status column.…
-
How to get all values to appear on the widget if the data value is 0?
I am trying to rate this 1-5 based off data from a survey. In this example, no one has selected 2 for the classroom training question- so the 2 doesn't appear on my widget. How do I get it to appear if the value is not selected or 0?
-
managing a dropdown field from a single source used by multiple sheets
we are tracking courses taken by folks throughout our org. each student (apx. 58) has their own sheet (student record), tracking the courses they have taken and the date completed. this is how the owner of the process currently wants this managed. the course catalog is relatively static and we would like it maintained in a…
-
Is there a way to have the legend options go in order based off of the percentage? Most to least?
I want a better way to show the preferred items based off of the percentages. Is there a formula or a better way of showing this data more efficiently?
-
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get the…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
If a cell contains three specific values, assign a numerical number
Hello community, I'm relatively new to Smartsheet and need some help with a formula. I am trying to have a number appear in a helper column when three specific options from a multi-select drop down list are selected in the same cell. I have included a screenshot of an example of what I am trying to do. If Option 1, Option…
-
Index between a group of dates to return a corresponding row value
I need to add a formula with the "period end date" to have it automatically update to return the "period rate year" that it falls within - e.g., 1/31/25 falls within 4/1/24 and 6/30/25 so it returns 2024 in the yellow.
-
Need Help - Formula to link to specific Site with ID number in URL from SS Column
Hi everyone, I am struggling to replicate a formula that I currently use in Google Sheets. We are a company who creates daily online puzzles, and a column (Column B) in our sheet has a manually-inputted puzzle ID number. Once we type the ID into Column B, Column C has an Array formula that then turns Column C into a…