-
Primary Rows
How do I create a new primary row in SS? One that carries sub heads and rolls up to the calendar?
-
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.
-
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with: =IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"") However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion…
-
Mail Merge with Google Docs to One Document
When I mail merge with Google Docs and set the outup to individual files, all files format correctly. However, when I set the output to combine all docs into one file, the formatting is all wrong. Does anybody know how to correct this? Thanks!
-
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
-
Rows Disappearing after having been moved from the origination page.
We have our sheet set up to where 1 sheet is used for order origination; the row is then moved to the sheet of the person who will be completing the task. The person will see it on their sheet and is able to change the status to accepted; however, in time, the row disappears all together. This is causing a lot of issues…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Cashflow Overview from Date columns
Hi all, i have checked almost every single discussions, but still looking for my solution: Case: building houses with 6 payment steps from our customers (revenue), and consider 6-8 payment steps for our contractors (cost) Note: this part we are able to do 1.) finally have a mastersheet with follow columns: January-December…
-
automated movement between parent grouping for roll up sheet?
Is it possible for a row to "automatically" relocate itself from (1) parent child grouping to the NEXT parent child grouping? Right now, I have to manually move them. I have a roll up sheet for our design clients. The roll up sheet is organized by stage of process and all information is auto filled in from the actual…
-
Security: why is a stranger requesting access to my smartsheets?
Received an email today from smartsheet saying some stranger is requesting access to one of my smartsheets. How is this happening?
