-
Median with criteria
Hello! I am trying to get the median days to complete for anything that is Bank of America, Chase Bank, etc. etc.. I have tried using the entire column in the formula and also specifying the specific cells and both returned with errors. The formulas I have used are the following: =MEDIAN(COLLECT({Days to Complete},…
-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Having automated backups (such as weekly) the formulas also included
Having automated backups (such as weekly) the formulas also included. It would be so good!
-
Text to Rows--Possible?
Hello, I've been all over the community forum and looking at various brilliant solutions, but can't seem to figure out how to do what I need. I have a form that has a field (Information) for a list of Number and Date entries. Instructions tell users to use a semicolon as a delimiter. I need to parse them into separate rows…
-
Formula Help: Choosing Most Recent Fields Across Sheets
I’m working with two Smartsheet sheets: Sheet A: Tracks courses taught (each row has 2 instructors + 2 courses — both instructors taught both courses). Sheet B: Lists instructors. I want to display the most recent course(s) they taught, pulled from Sheet A. My challenge: Because Sheet A has two instructor ID columns…
-
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")
-
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?