-
Dynamic Hierarchy
I am in the process of developing some work flow sheets for my team and I would like them to do the bulk of their submissions via web forms. Is there a way to create dynamic hierarchy whereby when a form is submitted, x criteria places that new submission under the correct "Parent"? Let's say that I have 3 Categories…
-
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…
