-
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…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Unparseable error being returned
I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated Regards Michelle =IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Date Problem
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange results. It would be nice if Smartsheet could…
-
Troubleshooting formula and or row
I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= Today@row - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why this is the case. Does the master sheet need to be purged for underlying errors of some kind. I can't duplicate the error…