Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the erro…
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…
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 wi…
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 …
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 rev…
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 rand…
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 d…
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 Dat…
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 schedul…
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", …