-
Need help on Summing Values based on drop down menu that contains text options
Hi, I have a question regarding using formulas and drop down menus. Similar to an FMEA, I want to have dropdown menus (High, Med, Low) for the severity, occurrance and detectibility. Then I want to have a formula that produeces a RPN (Risk Priority Number) by assigning the value 10 to High, 7 to Med and 3 to Low and…
-
Count Past Due and Coming Due Items
I would like to count past due and coming due items. For Past Due, I have a variance column that I have been able to use =COUNTIF(Variance2:Variance31, >0). The issue I have is that it is also counting completed tasks that had a variance but have since been checked off as done. Is there a way to haev it not include those?…
-
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
-
cant add or hide column
I have the majority of functions greyed out. Screenshot attached. Any suggestions?
-
Link data into a cell out of an attachment
Hi, Is it possible to get a cell auto populated from data in an attachment in the form of a PDF or Excel? Our goal is to reduce manual capturing of data that continually changes. Y
-
Can recurring update requests for multiple lines be filtered by complete?
We have a recurring update request sent weekly with all the rows that are assigned to a person (the person is not a licensed user). The person has to scroll through all the rows each time, even if the task is already marked as complete on a prior week. My question is, can the automatic recurring update request only send…
-
Dashboard
I cant find if this question has been asked before... Can we show Calendar view in Dashboard?
-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…
