-
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 =…
-
RYG formula
Can anyone help with a formula that uses an RYG (red, yellow, green) to set the status of a task based on its percent complete: If a task is less than 50% complete, turn the RYG light "Red" If a task is between 50-99% complete, turn the RYG light "Yellow" If a task is 100% complete, turn the RYG light "Green" Thanks
-
Locking Values in Row
I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes, obviously the cell in Sheet 1 updates automatically. I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed". The values in Sheet 2 may change once a year, as we adjust…