-
Copying formulae on sheets where the input is through the forms function
Hi Smartsheet team, My team and I use smartsheet to track our business development opportunities. When we get new leads our team use forms to input the data they need which then adds a new line into our smartsheet doc. However some of the cells in the sheet use currency formulae which do not replicate when we add in a new…
-
Is it possible to change the layout/ style of the Gantt chart?
Hello, to present an overwiev of the projects I´m managing with Smartsheet I need a more "presentable" version of the Gantt chart. Is there any chance in Smartsheet to make the Gantt look different, for example to make some tasks thicker than others or to change the entire form of the chart? As far as I know it´s not…
-
Manual cell entry/autofill second cell by referencing another sheet
I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, Owen
-
Slow updates on Formulas and Cell Links
The last 24 hours have been a nightmare. I have been doing maintenance on some of our data sheets which have formulas and that link to roll up sheets. The cells are taking a long to to update -and in some cases haven't updated at all (i.e. I can see in the cell history when the last update "cell-link" update was and it was…
-
RYG formula with a date reference
Looking for formula help with RYG referencing a date column. I want a green ball if the expiration date is more than a year away, yellow ball for expiration between today and 365 days and red for any date in the past.
-
If outcome of Formula is 0 show blank
Hi All, I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is also displayed in the chart, and don't want this. So is it possible to make the formula…
-
Adding "Contact" Widget at my Dasboard
Hello, I'm a starter in Smartsheet and try to build a Dasboard for FM KPIs in a Building. I also want to add a widget that displays the building managers (with picture, role, and contactdata - max. 2 Persons). Enclosed you find two pics I found on other Dashboards. Witch widgets where used therefore? Or what do I have to…
-
how to delete multiple unaccepted invitations?
Hello, I have a question about user management I would like to delete 50 unaccepted invitations. Line by line is long. Is it possible to do it all at once? Thanks
-
Amount of Requests per Lawyer
Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols") This is what I have right now (changing name for…
-
Update Date when Health Changes
Hi All, I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask: "When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the change occured" Simply, we need a way to automatically track what day the change in health…
