Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
CONCATENATE Formula Help
First, I had the following formula to return the number of tasks marked done over the total number of tasks (i.e., 10 / 50 complete) , then realized Smartsheet did not support the CONCATENATE function. =CONCATENATE(COUNTA($[Done]$2:$[Done]$51) "/" COUNTA($[Task Name]$2:$[Task Name]$51)," completed ") So, then, I tried the…
Connect reporting tools to a smartsheet REPORT
Smartsheet reports is hardly what i would call "reports". It just combines data from multiple sheets into a single sheet based on creiteria. Great. But that is just a start. That is just raw data...there is very little insights you can draw from that and it's precisely the stuff management does NOT want to see (raw data).…
Report Widget SIGHTS - word wrap for Sheet Name Column
I am pulling in the column: Sheet Name through a report widget and the sheet name does not wrap. All other columns do appear to wrap. Is there something I can do to have the Sheet Name Column wrap? The Sheet Name should be FQHC Look Alike Work Group. Thank you
Modify a Smartsheet I didn't create
I'm having trouble and I'm not able to find the answer using the search community. I'm helping another licensed user to modify their Smartsheet for use. That requires me to add columns, rows, equations, etc. First step was the other user made me editor. I was able to add/delete/modify rows and cell equations but I was not…
Alert date format is different
Hi, I have set my date format to dd/mm/yyyy and works fine in my sheets. However, when an alert is sent it enters my inbox in mm/dd/yyyy format. Is there anyway to make it consistent?
native dynamic drop down functionality- Card View & Reports
I know there are many different discussions requesting dynamic dropdown functionality native in Smartsheet without a third party solution but I feel the need to start another to emphasize the importance. I believe the need makes even more sense with Card View functionality Smartsheet recently introduced…especially in an…
#DIVIDE BY ZERO” error
I have a formula in Smartsheet that calculates Accuracy by using the following formula: Estimated amount-actual amount/actual amount. Until the “actual amount” is filled in (sometimes weeks or months later) the formula returns a “#DIVIDE BY ZERO” error. The error is fine as far as the calculations go on my pivot tables.…
Emailing row updates -- CC:
When mailing a row upate, would like to have a CC: option. Thanks, AEG
Turning on auto numbering
How do I turn on auto numbering for a column? I have followed the instructions in the help section however the cells in the column where I have turned on auto-numbering seem to be frozen and there are no auto numbers in them. The instructions seem simple enough but aren's working for me. Is there something I'm missing?
Card View _ Publish link
Hello all together We Publish our informations about A Publish link in our İntranet . But is not able to Publish our CARD VİEW and GANTT VİEW ıs there anything ı dont know
