-
Automate RYG Balls based on 3 columns.
Hi, I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green. Thank you !
-
Autopopulating contacts using vlookup
Hi, I have a sheet with several formulas, including a =vlookup on a text cell and =Join (). All these formulae autopopulate when a new row is added manually of via a form submission. However, I also have a contact column which, while successfully pulling the contact information into the cell using a =vlookup function, is…
-
Formula to change text
Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is within 2 months, I want the status cell to say "short term", if it is within 4 months, I want the…
-
CountIf and Exclude Status
Hello! I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13). I want to display the current number of Client or Internal requests and omit Completed or Declined. Any suggestions are appreciated!
-
Smartsheet Update for Attachments
#1 - Strongly DISLIKE #2 - Is there any way to go back to the old attachment format window for rows? The new side bar with multiple clicks to download is super frustrating and is not functional for what we do. Bring back the old attachment window please!!!! What used to be a one-click to download is now several. If there…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
Adding Checkboxes
I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula.
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
Google Calendar
Hello! I am new to smartsheet...learning as I go. I have published my sheet to my calendar, and I have overlayed my calendar to my sheet, however my appointments on my google calendar that is NOT sheet related (ie. speaking engagements, meetings and conferences) is not overlayed onto my smartsheet. My sheet is utilized as…
