-
CountIFS w/Three Sheet References
I am trying to get a CountIFS formula to work that includes three sheet references and I get errors no matter what I do. I am trying to count the number of tasks with the isParent checkbox not checked, the Status equaling a specific value, and the Category also equaling a specific value. The values are represented in the…
-
When a parent is marked complete how to mark remaining children tasks complete
I have a list that has many parents in the sheet and below that are 4 children tasks. Each have a due date. Not all will need all 4 tasks. How do I have it so when then parent is marked complete it will mark the 4 children tasks complete. This way it will not send notifications if overdue since they will be marked…
-
How to Assign People from another Contact Column
I want to assign people in a column to be the same as the contacts assigned in a previous column, unless the user overwrites the new assignment. I.e. if the Stage = "Step 2", the Step 2 Owner will be the same as the Step 1 Owner - unless overwitten to be something else. So far I've found that the "Assign People" automation…
-
Help with an Index Match
I have two sheets and I want to use a formula to tag the legal responsible person based on the entity. I can't figure out what index formula to use, please help! The formula should be in the legal reviewer column and populated from the first screenshot
-
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!
-
Field Service Management in Smartsheet
Has anyone built a Field Service Management solution in Smartsheet? I need to maintain a database of; store locations technicians, their backup tech and their backup of the backup tech dynamic schedule of availability of said technicians I envision some form of a 'lookup' worksheet where appropriate and relevant data from…
-
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…
