-
Using Formula in the Predecessors column
I'd like to include a variable in my Predecessors column. So, for example, I might have a column "Contingency" and want the Predecessor formula to be "2SF-[contingency]" - where it takes the value from the contingency column (which may be 0 or may be several days). Then, if someone updates the contingency column, it…
-
Combining AVERAGEIF and AND Functions
Hi All, I am wondering whether it's possible to combine the AVERAGEIF and AND functions together to meet 2 criteria. In my case, I'm averaging time - {X} is in minutes hence the division by 60 to convert to hours and the 2 to round to two decimal points. The below works as expected. =ROUND(AVERAGEIF({X}, {X} > 0) / 60, 2)…
-
Dashboard Widget show only Current User information
I am wondering if there is a way to set up a Metric or Chart in Dashboard that will show only the data that applies to the current user. Example: Metric Widget is set up to show all lines on a sheet that are open vs lines that are closed for a team of 7. Is there a way that the chart would just show Team member 1 the…
-
basic formula to auto-populate one cell based on selection in another cell
Hello - Hopefully an easy question, I just have a mental block when it comes to the formulas. I have a "Location" column with six options (single select). I have another column, "Representative" that has 4 selections. I would like the Representative column to auto populate based on what is selected in the Location column.…
-
Nested OR, AND, IF
Hi All, I am only a week 1 user so forgive if this is a little basic. I have a flag/no flag column in my sheet that currently indicates whether a report is overdue based on the status of the project, due date of the report, todays date and whether a report has been submitted (entered in the shseet as a date). The format…
-
Help marking off a guest list from a registration sheet
We’re planning a large meeting. We’ll be using Smartsheet for registrations via a form. There are about 80 guests we want to make sure register. I have attached screenshots. Sheet A is the guest list. Sheet B will be collecting the registrations. Is there a way to set up a cross-sheet formula that marks off each person on…
-
Using IF formula to reference any change in cell (adding a value)
Hello Experts! I was wondering if a formula like this is possible: =IF([Confirmation #]@row = "any value", "Confirmed") When a confirmation number is added to a cell, that means the item is confirmed. What can I put in place of "any value'? I am just not sure how to do this in the context of my larger status formula:…
-
Multi Select Drop Down Parsed to Separate Rows in a new sheet
I have a column in one sheet that is a multi-select drop down for ease of population for the user which I need parsed out in another sheet. The user will fill out this template (sheet 1) first to choose the risks associated with each item: The data in sheet 1 is linked to sheet 2 via cell linking, but I need the risks to…
-
Countif with dropdown multi-select colum
I have a dropdown multi-select column with about 10 dropdown options from which to choose. So obviously I can choose more than one option in each cell! I'm trying to create a chart for my dashboard that shows how often each of the 10 options is chosen. So I've created a countif equation for each of the 10 dropdown options…
-
Planko Status Column - is this possible?
Sheet 1: Col 1: Numbers in row sequence, i.e. 1111, 1112, 1113, 1114 Col 2: Status: Show / Unavailable Sheet 2: Col 1: Last Name Col 2: Number (index/matched from Sheet 1 based on Status Columns) Col 3: Status: Show Sheet 2 is a manual row entry sheet, and what I’m hoping to achieve is that when the status changes in Col 3…