-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
I am not able to access the conditional formatting button?
Hello! I have been using conditional formatting for my calendar view, but when I went to try today, I couldn't find it anymore! Did smartsheet change the formatting? How can I get to the conditional formatting setting?
-
Problems with conditional formatting on my sheet when it's not listed as a condition
I'm having the weirdest problem on one of my sheets. Below are the only conditions on my sheet, but adding a new task or row applies the pastel yellow to the row. In another cell it's applying a navy background. In the same column it bolds all the text and turns the font color white. None of these appear to be conditions…
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
Need help creating formula to show # of Children that are complete & percentage
Should display something like: 2/10 (20%) # completed tasks / total tasks (percentage of total) Can you please help?
-
Reminder workflow for past due approval
I'm essentially a nube to Smartsheet (so be gentle please), though I've come up the learning curve some distance. I've drafted an app to track a form thru the approval process. I'm at the stage where I'm trying to add bells-n-whistles to the app. That includes a reminder workflow to approvers who have not responded to the…
-
Multiple Forms to One Sheet
Hello! New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column…
-
Lookup multiple values from a dropdown cell and SUM
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into my Sheet1[Total Points]. Is there a way to do this in Smartsheet? Please see attached images Thanks in advance
-
conditional totals per column
Hi all Hoping I can find some help on this formula, Trying to figure out how to create sum totals of PO value column at the top of each of the first 3 columns (FERG JOB #, FVLV#, JOB SHOP #) if information is present in those cells. contingent on any of the items in the drop down list from PO/SDR down being selected. Any…
-
CHANGE CELL IF CRITERIA ARE MET
Hello, I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 to show if the date and time is chosen the status in Cabin 1 - Status is not "BOOKED" not Available. How can I do that?