-
Dashboard chart from sheet
Hi all, I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue. However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...." Any advice if I can do this or it just isn't with the…
-
What is the formula to flag duplicates from a multi-select drop down column?
Here is the formula that I have been working with. Currently I have it build out to where it flags duplicates but only if it is a "single-select". As soon as I select multiple times in the cell, it won't flag the duplicate anymore. My goal is to have any duplicate flag so that people aren't scheduling over a time that has…
-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
-
Count number of times a value appears?
I have a sheet for tracking the amount of defects that occur. Each defect report has a "Machine Name" value which is selected via a dropdown. What I'm trying to achieve is to have a counter, in any form but preferably a widget or a column, that would track the amount of times a report pulls a machine name. I.E. if Machine…
-
Smartsheet Removing Zero
I have a course code 30657.201930 that I am pasting into a cell that is Text/Number. It drops the last zero, so it says 30657.20193, not 30657.201930. I tried adjusting the decimal points, but I cannot get the zero to stay. I'd like to keep the ability to paste the course code from another document, but I want to be sure…
-
Is there a way to update referenced sheets using vlookup and/or index and match?
Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake listing sheet - has our projects intake, which eventually end up as an "approved project". Each initiative has a unique ID…
-
help with formula's
hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2 Power/Motor Cable List Tracker Range 1}, 1, false)) Motor, 0) I would like it to say…
-
OFFSET function equivalent?
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally achieved...I need help finding a workaround. My situation: I have a sheet of data where the columns contain individual employee…
-
Formula for at-risk flag, due within 3 days
Hi! I would like to have my at-risk flag turn red when 1) a due date is within 3 days or past the due date and 2) its not completed. I am using the below formula but it doesn't work: =IF(AND([End Date]3 < TODAY(-3), NOT(Status3 = "Complete")), 1, 0) I tried it with making it TODAY() and it works for overdue items, but I'd…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…