-
COUNTIFS not working
Hello, I have attempted to COUNTIFS from one smartsheet to another, however I have had no luck. Once smartsheet is being used to collect numbers and the other is getting information pulled in from Jira. As you can see in the screenshots I am trying to count certain words in text fields and not a matching character in a…
-
Countif for multiple selection column
Hi I'm trying to find a formula that will count a particular option in a multiple select column on another sheet. I've tried using CONTAIN, HAS and FIND but neither appear to work - I get an error or it just returns a zero, when I'm expecting 1. Any help would be greatly appreciated. TIA Cheryl
-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…
-
Profit percentage calculation
Hey all. Trying to get a profit percentage formula. Columns are: "Price Bought" "Price Sold" I want to get the profit between the bought and sold, so if I bought for $1200 and sold for $1000, that's 20% profit ($1200 / $1000 = 1.2) What's the correct way to do this?
-
Worksheet population with Formulas
I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow…
-
My average formula is disappearing....
Hi SS World...very basic user here trying to determine the average of children rows in the parent row. Tried using 2 different formula's in the parent row (white row): =AVG(CHILDREN()) =SUM(CHILDREN()) / COUNT(CHILDREN()) The average will calculate correct initially but then Smartsheet Automation deletes the formula and…
-
Change cell color based on date from another sheet
Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color. So, for example, if project 1 timeline had a date associated with 9/12/21 then the cell joining those two would…
-
Formula help to view a specific month
Hello, I currently have the formula below. Curious if anybody could help me change the formula to be a specific month like July, June, September. Any help is appreciated =SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))
-
Formula - Extra help w/ a COUNTIFs formula that takes into account when booking from same location
I have a smartsheet that calculates the cost of equipment when its being booked by a garage. Everything is working well, except my formula is calculating the cost when the equipment is booked by the same garage. Example shown below: Equipment: Bobcat Wooster is being booked by the garage called "Wooster". So in this case…
-
Editing a URL string
Hi I need to modify a URL string. Should be a column formula. The original string is test.test.com/editor.html/content/folder1/folder2/folder3/folder4/catalog/section1/e/product.html the result should be test.com/folder1/folder2/folder3/folder4/section1/product.html The beginning of the URL needs to be changed /catalog/…