-
Conditional Formatting one row at a time
Hello, when I set up conditional formatting on a sheet it applies to the entire sheet. I would like to set a different criteria for each row and when the conditions are met, I would like that row to turn red. How can this be achieved?
-
IF, AND, OR (all 3) (formula) Help
Hello! I am trying to create a formula to count if any kind of combination of the below is met: =IF(AND([WU Enrollment Complete]:[WU Enrollment Complete], 1, [WU Pending]:[WU Pending], 1, ([Email 1]:[Email 1], 1, [Call 1]:[Call 1], 1, [Call 2]:[Call 2], 1, [Assigned to]:[Assigned to], "MyLe Nguyen") 1,0) It seems like the…
-
Calendar App: why can't I see settings?
First let me say that we're new to the Smartsheet Calendar App. I started the Calendar worksheet but my manager wanted a chance to set-up the Calendar App this time around ('cause it's fun). Even though I'm the owner on the worksheet (she's the Admin - see attached screen shot), I cannot edit the settings in Calendar App…
-
Automate update requests for every week if status is not 100%
Hi All, Is it possible to set up automated update requests until such time that the particular task is complete? What i am trying to achieve is: I have a large project involving 360 sites, i have created a sheet with 360 rows and 8 columns of status for different tasks. When a column is complete it adds 12.5% to the %…
-
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
-
Sheet Name Appearing within Google Calendar Milestones
I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the…
-
Formulas in Symbol defined columns
I've defined a column to use RYG. If I click on a cell in that column I get a drop down to pick from the 3 color ball options. Now I'm putting a formula in that cell that will do a calculation the picks R, Y or G. So now all is good; however, If I click on the cell where that formula is and click on the drop down list, it…
-
Update Request
Hello, I am not seeing the envelope in the far left column titled "i" where I normally do in my other sheets. Can anyone tell me how to fix this? All I see is the bell (see attached).
-
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
-
Best way to layout sheet for multiple user data entry and charting
New to the program so am looking for some guidance to head down the right path. Lets say I have 10 different metrics that need to be updated once a week for 52 weeks. Each metric is owned by a different employee. I want them to enter their data, not send to me to enter. At the end of the day I need to be able to print one…