-
Start / finish Dates
I need to show the proposed start/end dates in the program to my client. He also wants to see actual start/finish dates. Is it possible to do this?
-
An Admin deleted bucket
Saw a few threads regarding years of no action by SS to give the Admin the ability to restore deleted rows. My suggestion, why not allow users with edit rights to delete rows, but not allow them to see the deleted items. This is where the admin will go when the team screams that someone deleted a row or rows. SharePoint…
-
Conditional format using two columns
Hi, I have two columns Planned start and Actual start. I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start. Please assist. Y
-
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
-
Web Forms
The only way that I know to add an attachment accessible to the user is to create a link. (I'm not referring to the user uploading a document to the web form.) Is there another option?
-
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…