-
Sharing out Statistical Data
Hi everyone, What templates would you recommend for a report exclusively showing statistics? No date information will be included in this report (beyond the name of the month); however, there are three layers of statistics I need to share out by month. Any ideas? I look forward to hearing any and all suggestions- Alyssa
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Alert based on Harvy ball or "last changed date" system column?
I have a harvy ball that shows the progress to completion on a task. Is there a way to send a conditional alert to someone on the task line when the harvy ball gets to a 1/4 or 1/2 full? or even when it changes value (other than any change) Also is there a way to get a tickle when a sheet is not complete and has not been…
-
Recurring sending of a report
We find ourselves needing to send a report on a recurring basis on the 1st & 3rd Friday of each month. However, when there is a 5th Friday, we'd like to have the report sent then, as well. There is the option to send on the last Friday, but that would include sending whenever that's the 4th Friday. Currently, I have to…
-
Duration in parent row not calculating
I have a parent row that is indicating duration of its child rows as 78,324 days when in fact it's actually 53 days--February 1 - April 29. (I made sure the dates were all in 2016). I had one row that was showing several thousand days when it was actually 21 days. I fixed that and saved the sheet but the parent row is not…
-
"Processing" Today date in date range.
Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…
-
Counting non blank cells
How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.
-
Mapping with Smartsheet Labs
My company is a private emergency response service. We were very excited when Smartsheet Labs came along and presented us with the ability to map our clients adresses. However this feature turned out less than great due to it using Bing rather than google maps. Adresses that should be easy to locate simply wont map on…