-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
-
Check if cell is empty then join.....
Hello, Friends. New user who like Smartsheet very much. Situation: A general user provides input via the smartsheet form. Once the form is submitted, column B is populated by a Smartsheet number generator (next sequence number). Works great. I have built a JOIN which runs great manually. I would like to run the JOIN only…
-
Update Request: How to set permissions on cells?
Currently, when sending update requests to partners, the respondent can see AND edit all selected cells in the row. Is there a way - or a plan for such functionality - to allow respondents to the update request to see certain cells, but only edit specific cells (maybe this would be an additional checkbox or the next step -…
-
Selecting the Next Task
This is a bit of a weird question but I'm trying to figure out how to make SmartSheet inform me what my next milestone is for a project. Basically I have a series of projects (say 40 or so) that each have their own project schedules. In those schedules, some tasks are marked with a checkbox to indicate they are critical…
-
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…