-
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".
-
Have an IF Statement Change the status of a field when a value in another column is less then 2
Title is worded weird, but here's a better explanation. I am looking for an IF Statement that reads "If Total Emails per app is less than 2, then change status to Additional Research Needed." Here's my attempt at the formula: =IF([Total Emails per Application]:[Total Emails per Application] < 2, "Additional Research…