-
Current user metric widget
I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them. I have a sheet summary formula that counts the total visits and…
-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…
-
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…
-
Chaining together IF statements
I would like to know if it is possible to chain together if statements using the & symbol, similar to Excel. e.g. =IF(Brand@row="","",Brand@row&" ")&IF(Model@row="","",Model@row&" ") I have used this method in Excel, but this doesn't work in Smartsheet. Is there a way to make this work?
-
number of cross-sheet references has already been reached
Hi team, I am getting error "number of cross-sheet references has already been reached" while adding formulas to a sheet (let's call it sheet B) that are using cross functional references referencing Sheet C. I am confused as I have another sheet (sheet A) with more references and I did not get the same error. Also if on…
-
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.…
-
COUNTIFS for multiple listed characters (not using numbers) in multiple columns
Good Evening Community, Column A contains the formula, see below Deliverables NOT Completed contains all the listed values I will need to incorporate in this formula. Deliverables Completed - (COMMS)/ Deliverables COMPLETED - (PROG)/Deliverables COMPLETED - (DEVE) all contain the same listed values from Deliverables NOT…
-
If Condition
I have this condition which works well (copied from line 89 of my plan) =IF([% Complete]89 = 1, "Complete", IF([% Complete]89 = 0, "Not Started", "In Progress")) I'd like to add two conditions: 1st: if the %complete is 90%, then the cell should change to "Scheduled" What I thought would work: =IF([% Complete]85 = 1,…