Formulas
Discussion List
- 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", …
- 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 l…
- 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 t…
