-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
Sort, Second Sort, Third Sort (then by, then by)
Trying to sort, then by, then by. Anybody find a work around, second and third sorts pushing tasks to the very bottom of first sort. When the first sort has exhausted all available data I would like items that meet second sort criteria to start in, not be pushed to the very end first sort.
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Using Contact Lists within a Form
Can we use a contact list within a Form and allow multiple individuals to be selected like when working within the sheet itself?
-
Symbols not showing in reports
I have a large Smartsheet grid that contains important information against a list of devices. Some of this information shows the status of some testing and is displayed as symbols. Rather than share the whole sheet with staff, I would rather share a selected few columns in a report. However, symbols & dropdowns do not…
-
Dashboard Chart Displaying Currency for Viewer
Hi Smartsheet community, As an Admin, I setup a dashboard with a chart showing data with $ signs. A viewer sees the same dashboard chart with US$ signs. Is there a way for the viewer to see only $? Thanks for any suggestions! Dee
-
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
-
Feature Request-Bullets in Cells
I am sure this has come up before, but I couldn't find it in a search for bullets. I am trying to use Smartsheet for proposals and it would be so helpful to be able to format a long list of items with bullets. I realize I can create them with bullets in a text editor and paste them in, but it would be much easier to work…
-
Clean up Sumif Formula
I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula =SUMIF(@{Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Client Seminars /…