-
Populating text cells that show minimum value
I am in the process of creating a sheet to populate low bidders. I have two columns; vendors and total cost. I've included a cell formula in the total cost column to automatically populate the low bid value : =min(cell1, cell2, cell3, cell4, cell5). My question is, how can I create a cell in the 'vendors' column to…
-
Conditional Formatting on Web Forms
Does anyone know if there is a way to implement conditional formatting on web forms? For example, if I have a web form to populate a sheet, I want to be able to implement rules to email certain people based on a specific value selected in a drop down on the web form. I did try to figure this out using Zapier, but couldn't…
-
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…
-
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
-
Rookie Help with Due Date and Overdue
I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?
-
Change Status Bubble Color Based on Percentage
Have tried using conditional formatting to achieve this with no luck. I have a column of % complete with percentages in increments of 5. I then have a seperate column of status that I am using a gray, red, yellow and green ball image. I'd like to for the color of the ball to change based on the percentage chosen (i.e. gray…
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
-
Conditional Formating : Done/Status based on items below it.
I am using a sheet to tract information being sent by candidates. Is it possible to make the Red Dot in the "Done" Category next to "Candidate Name" Turn Green automatically when all lines associated with it are turned to green/done. I've been trying to get conditional formatting to work but I can't figure out what the…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
