-
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…
-
TODAY() Automated workflow birthday not calculating correctly
We've automated a work flow for birthday notifications - so we can celebrate folks. The workflow/notification shows an incorrect calculation - age = 20, when it should be 21. Here's the notification: And here's the data we're pulling from, showing the correct age calculation: I'm assuming this may have something to do with…
-
COUNTIF year is current
Can anyone tell me what is wrong with this formula for counting rows containing the current year? =COUNTIF([Date Completed]:[Date Completed], YEAR(@cell) = YEAR(TODAY()))
-
SUMIF using or & and & contains
I am needing to sum the Estimated Budget for everything that has a Status of "Proposal with Client" or "Sales Order with Client for Signature" AND if the Session-Service column contains "Assessment" or "Test".