-
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/…
-
Countif Issues
Hello, I'm trying to create a summary report based on the number of registration per week. Can you help me with the formula as countif function does not work. Thank you!
-
Formula
Hi I'm trying to return a boolean based on another column - If the column is blank, or the date is within the last 7 days, I need a 0 to return, if it's not blank and the date is greater than 7 days from today, I need it to return a 1. I'm currently using this formula: =IF(OR([Current & Pipeline Last Updated]@row =…