-
How to calculate if a date is 6+ months away, 3-6 months, and <3 months
Trying to figure out a formula to calculate if a date is 6+ months away, 3-6 months away, <3 month away, or if the date has already passed. The desired output is 1 if 6+ months, 2 if 3-6 months, and 3 if <3 months or already passed.
-
Help needed - Conditional Formatting a multi-answers cell
Hi all, I have tried about everything I could to create a functional rule of conditional formatting but to no avail. Here is a detailed look into what I have and need : I have around 5 different columns for which I need a rule to apply individually. Basically, each column respresents a task, while the row represents in…
-
Multiple contact list cross linked with a single choice list
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
-
Lagging Formula Calculation
Hi all, Question: What makes cell formula update/populate a value and why would there be a long delay? Here's my issue: I noticed a request was stuck in my workflow, and when I reviewed the cell history on the helper columns I noticed the culprit was a cell with a relatively simple formula that didn't populate a result…
-
Convert Value To Static
I need help, please! I created a process that allows employees to request deactivation periods from their snow assignment. The ogranization allows for 5 employees for days and 5 employees from nights to deactivate at one time, per day. I am using the following formula to retrieve the number of slots available:…
-
Smartsheet University Free Training
Hi, I've been using Smartsheet for almost four years. And I am the current lead in our company, although I have some knowledge, I haven't undergone formal training. All are from personal review and learning. I want to ask if there are free certifications or all have fees in Smartsheet university? Thank you!
-
Change the MAX of Children to 0 if it's a negative number
I have a Parent row that is showing this =MAX(CHILDREN()) Which I definitely need. The intent is to show if an institution needs to change hours if there's a positive number. However if there's 0 or a negative, the institution is on track. However, the formula is also showing the highest negative number if the institution…
-
Predecessor question
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
-
Copy the VALUE ($) from a Formula (Cell) into another Cell
I know you can use a formula like this: =[Projected Payment Milestones (+)]@row to copy the "value" from one cell to another (because that cell is a formula); however, I need just the "value" formatted as a number ($) to be copied; because in my REPORT I am not able to edit the data as it is recognized as a FORMULA (fx) Is…
-
Need to parse text and Remove Data
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…