-
Has anyone else had VLOOKUPS start randomly throwing errors despite no changes made?
I've noticed since Thursday that on one of my sheets, the VLOOKUP will randomly throw an #INVALID ARGUMENT error despite the formula already working and having no aspect of it change. It seems to randomly do it sometimes when opening the sheet, but I've noticed that it creates an error every time if a new entry is…
-
Multiple IF statements/Managing large formula.
Hello Smartsheets Community, I was curious if anyone had some input. I've developed a sheet that runs different formulas for different "vendors" in a column to get a final price based on the vendors data. It's become a very large IF statement as there's many vendors now (if vendor is Vendor 1, *do this* etc). I'd like to…
-
6 Month Anniversary Formula
Hello Everyone, I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!
-
How would up update this existing SUMIFS formula to add an additional criteria?
I have a current formula that but we have realized that there is one Team who's numbers are skewing the results and would like to have there totals excluded. =SUMIF([Cast Type]:[Cast Type], "Vendor", Estimate:Estimate) + SUMIF([Cast Type]:[Cast Type], "Contractor-Offshore", Estimate:Estimate) The Additional Column is…
-
IF formula based on other cells
Hi, I am trying to create a few different formulas based on the liaison change request being yes. I would like to #1 capture the current liaison's name in the previous liaison column #2 move the new liaison name to the current liaison column. Is this possible? I am sure I might need a helper column or two but unsure how to…
-
If Formula Help: =IF X symbol and X symbol are X, display X in this column
I'd like to select text in a column based on symbol indicators in a column. For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want to indicate that i should reach out to them weekly. See pic. Please help with how I can set up the formula to do this…
-
Can "@row" be used in the Intake Sheet Summary page calculation?
Hi, Just need a sanity check please. Can @row be used in the Intake Summary page calculation? I assume it won't work because it is a summary. However, [field]x:[field]xx (where x is the first row to consider and xx is the last) works.
-
Is there a work around to capture modified by for a cell instead of the row?
Hi everyone, I’m working with Smartsheet’s Dynamic View and I’m wondering if there’s a way to automatically enter the email of the person updating a specific cell into another cell. I only need the email to be captured when a particular cell is updated, not the entire row. Modified by will not work because that changes any…
-
Index Match returns "#No Match" for Project Manager but works for Project Sponsor
In Metadata, the Formula is basically the same between the two fields but Project Manager is returning #No Match and Project Sponsor works. The references are going to the correct places. Can someone please help me find the discrepancy? Thanks!
-
No Match error with Index Match
Hi, I have a column in sheet A that uses the Index Match function to collect data from different sheets. The formula worked perfectly with two source sheets, but I keep getting the #No Match error when referencing one specific sheet, despite double-checking the search value to ensure it matches exactly what I have in Sheet…