-
Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…
-
Calculating Total Cost for Rooming List with additional Hotel Matrix Sheet
I'm trying to calculate the 'Estimated Total Cost' for a traveller staying at a hotel. I have a rooming list sheet and a hotel matrix sheet. The rooming list has each traveller on each row and the '1' represents that they are staying that night. The hotel matrix sheet has the room types, dates, nightly rates and total.…
-
Formula to create a hyperlink
Is there an equivalent to this excel formula? =HYPERLINK("http:www.google.com", "Link to GOOGLE")
-
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.…
-
Alphabetize Using Formula
Is there a way to easily alphabetize a list using a formula in smartsheet? In Excel, I would use the simple formula shown below to assign a numerical value to each unique list item. =COUNTIF([Unsorted Range],"<="&[Specific Cell Value]) This formula doesn't work in smartsheet, so I'm trying to find a solution. I am working…
-
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…