-
Percentages not displaying correctly in Report Summary
Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…
-
Adding contacts to Group --> added to shared workspace?
I have created a group called 'Coding organizers' and added 3 members in this: myself Dirk John I have then shared a workspace called 'Coding test' with the group. Now all 3 of us have access to the workspace. What if a new contact/member called Judith will be added to the group 'Coding organizers'. Will she automatically…
-
All cards move out of lanes into Uncategorized
After reading all the similar posts as this that have no helpful conclusions, I beg of anyone who knows why after 18 years of programming, Smartsheet would automatically move all cards that have been assigned to lanes back into the Uncategorized lane, and strip the names from the tops of the other lanes. How can this…
-
Question about Forms - what limits does the form have?
We are wanting to use the form in our business for requests to be submitted, but we are wanting to only allow so many forms to be submitted each day, like a daily cap - is that possible?
-
Change cell value AND record a date in the same workflow?
Hi, I don't seem to be able to find a way to do both of these in one workflow. When certain triggers are met, I'd like to check a box in column A, AND record the date in column B. However, currently smartsheet allows me to just choosing one of those, not both. To be more specific, if I go with "change cell value", it does…
-
Auto populate street address location using Smartsheet mobile app
I've created a form for construction onsite workers to use in the field. One of the questions on the form is their location. I want them to be able to use the GPS function on the mobile app to fill in the street address into the form. However, it only fills in GPS coordinates and not actual addresses. Is there something I…
-
STUMPED: How to include US Dollar Sign in Report using SUM summaries
I have been working on testing out some reporting and dashboards. In a proof of concept report I built, I was able to add 2 summaries for Count and SUM. This report included the "$" in the summary (see pic 1). However, when I built out the 2nd report (using a copy of the first) I am unable to replicate it so the "$" shows…
-
Smartsheet certification - stuck in lobby?
I am trying to take the exam on Chrome with pop-ups enabled and I am in the...lobby? Assuming that I am waiting for someone to come and proctor the exam? There is no option to "Start Recording" and there's no support line for Invigulus, nor clouddesigns.io. Thoughts?
-
Trying to get a report filter to show what I need - any ideas?
Hi there, I have a report that I am using to show all the Smartsheet rows that are about artificial intelligence. I have several filters set using the "contains" option. As you can see, one of the items is AI. Unfortunately, this pulls everything that has AI, such as the word "contain." When I put AI in quotation marks,…
-
Why do I get a #Incorrect argument set error with the formula below/
=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row =…
