-
How can I automatically add data to the dropdown list ?
Hi all, Sometimes i need to add new data to a dropdown list but it's hard for me to add because it's in a lot of different sheets. How do i automatically add data to all dropdown list column? (Python, Automation, Make, Zapier etc.)
-
Formula to change cell based on info from another sheet?
Hi @Paul Newcome, you offered to help find a solution to a problem that was discussed in another thread if I started a new thread and tagged you... so here goes! (Thank you, by the way). I have a sheet that tracks progress through a workflow. One of the items I'd like to track is if a ID number appears on another sheet. If…
-
IF status symbol based on cell date or blank
I'm trying to write an IF formula to return a status symbol based on if a date column in my sheet is in the past OR is blank. Smartsheet keeps telling me my syntax isn't quite wrong, and I'm having trouble seeing where I've gone wrong. Here's what my formula looks like right now. =IF(ISBLANK([Expiration Date]@row), "Red",…
-
Index/Match instead Vlookup
Hi good day. I just created a formula to grab dates from another source sheet. The situation here that i created using VLOOKUP and read that it is recommendable to use Index/Match for this kind of situations. Can you help me to build the formula and including if there is #NO MATCH show in blank? Thanks in advance. Below…
-
COUNT IF, INDEX, MATCH
I have one table with a reference number, a sub-vessel number and a check box column to select the desired subvessel. I want to use a formula in another sheet to count the number of times a value is present in SOURCE(subvessel selection column), where the SOURCE(reference number) matches the TARGET(reference number) and if…
-
Capture Sheet Data Metrics by Current Year and Quarter
I am assisting our Marketing team with tracking social media statistics year over year broken out by quarter. I want to create a sheet summary field that captures metrics for the current year and a specific quarter to populate and auto-refresh on a dashboard to avoid manually modifying the metrics each quarter/year. Is…
-
Partial match with INDEX(DISTINCT(COLLECT(
Hello, I need to collect a list of values from my source sheet based on a search field (cell) in my target sheet. I have a very large subset of data that I'm pulling from, so I've divided it into 6 sheets to increase the speed of the lookup. Currently, I'm using the formula: =IFERROR(IF(OR(LEFT([Lookup Value]$2, 1) = "A",…
-
Help Summarizing Columns
Thanks for your help! I am looking to summarize in one column all of the reasons why something is red. For instance in row 2, I would like "why red" to be "Financial, Resources" because both of those two have red selections. Other than creating a helper column for each health status then joining them, is there a more…
-
Strange Request of Rounding Down against Laws of Mathematics
I've had a strange request. One that defines the laws of Mathematics: I'm calculating the time difference and then using this formula to round down. However, the formula is following the laws of mathematics and rounding up when it sees an 8 or 9. =MROUND(ROUNDDOWN(Difference@row), 5) E.g. In this example, the requestor…
-
Need help with formula IF PARENT, then INDEX/MATCH for Dupe Flag
First, thanks in advance for looking at my problem. I am sure I am making this more difficult than it has to be. New: Release Update Sheet Formula being added to this sheet in a Flag column Based on IF Parent Row This sheet has Parent AND Child rows Initial field for INDEX/MATCH is Release Column Release List Duplicate…