-
Make some fields required in update request form
How can I make some fields required or mandatory when sending update request form?
-
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?
-
Data Uploader - Expressions & Repeated Updates
Hello, I have three questions regarding Data Uploader. 1) In my source excel file I have First Name and Last name. I tried to build an expression to concatenate the fields (used =[First Name]+" "+[Last Name] but returned UNPARSEABLE which I would assume is because I am not referencing the line number. Is there a way to put…
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Multiple column count
Need help with a formula. It is to count total sites upgraded either to a interim or final result, but if the site has had an interim and a final it is only counted once. I have 2 columns with check boxes and need to count as 1 if a cell is checked in either column. If both cells in the 2 columns are checked also =1. so…
-
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…
-
Upcoming Release - Whats In It?
There is a new release coming. Yay! We were all just summarily notified of the upcoming release and the expected downtime. Any chance we can get a list of proposed changes included in the release? And please don't send me to the roadmap page with the generic message on releases and a copy of the release notes from the…
-
Card view settings
Is there any way I can view the cards showing only the columns with data from the grid view? For example i have about 20 columns on the grid view, and i would like a rule so that when i look in card view only the populated cells appear.
-
Error Message on Sub Tasks
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
-
About Time Calculation
How can we calculate time between start date and finish date? I want to know by hour and minute format?