-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
Is there a formula that will help me to determine if a task has any dependencies (IE: the opposite o
I work on some pretty complex projects and the templates we use have hundreds of tasks that are linked together using the predecessor column. Each project is slightly different and we usually need to delete certain tasks to refine the template into a new project plan. It can be a pretty big pain to delete some of the tasks…
-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
How to update dates to a new future date
Hi I use smartsheet as payroll check system. I normally maintain a group name, pay date, direct credit date. For some groups we pay weekly and for some we pay fortnightly. How do i automate date column with future date once i complete the payroll on certain date. Example Group Name Payroll preparion Date Direct Credit Date…
-
Populate date fields per status changes
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date. What I have currently:…
-
Formula Training
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…
-
How to do "OR" in conditional formatting
Hello, I have a column which receives answers from a form. The form is basically a test for nurses. I have conditional formatting set up in the answer column that if the answer arriving is NOT the correct answer, then the cell with the wrong answer turns red. Now the managers decided to change the wording in one of the…
-
Unable to Access File
Everyone in our company is unable to access a file that we have created ourselves. The attached error asks that we Request Access but no one is getting an email. Is there something else I can try? It is a document that has not been accessed in a few months. Would it be deleted after a certain period of time if that's the…
-
Have User Filing Out Form Include Clickable Hyperlink
Hello, I am trying to see if there is a way to have someone completing a form to be able to include a hyperlink to where a file is. It would then come onto the Smartsheet so someone else could click on the link to get to the file in a shared drive. Many of the files we work with are too large for attachments and a…
