-
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…
-
basic math in Web Form
I would like to see the ability to add, subtract, multiply and divide in a Web-form. Asking for financial information and need to add 5 or 6 boxes to have a subtotal. (at least one box is the multiple of 2 other boxes), Then deduct optional box for a final total on Web-Form. Now I ask the person filling out the form to do…
-
Last Column not available for view. -- recovered!
I have a large sheet (48-50 columns by 80 rows). I can not see the last column. It has a formula that displays either "not done" or "done". I use it to highlight "done" rows in green. I was working on another indicator and wanted to access that column and couldn't scroll over to it. Have I met a limit on the width of the…
-
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…