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. Archived 2015 Posts
Archives for November 2015
Discussion List
Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
Restore from backup
I have a backup of Sheets folder. How can I restore this folder from the backup .zip file?
Formulas and Sheet Saving
All of the sheets in my solution have a date column for "Today". =TODAY() I use formulas in several other columns to determine if the checkbox column for Current Qtr should be checked. (same for Previous Qtr and Next Qtr) I use the checkboxes in report filters. Problem: Because my formulas are updating sheets daily, I have…
Embed a smartsheet iframe into Google site?
This seems like a no-brainer, and maybe it has to do more with google's secret jealousy of SS, but why the f*#k can't I embed a SS iframe into a Google Site that I make for the company? This seems like the first thing any joint venture between google and SS would ensure possible. Can you please help?! :-)
How do I add costs by phase & task?
I am looking to add costs to my project plan (Smart Sheet). What is the best way. In the end I would like to be able to report on the following: Budget, Costs to Date/Actuals, Encumbered, Forecact to spend, and Ending balance.
Report Not Finding Matches
I'm working on creating a report, but keep failing to have any matches pulled from my Smartsheet when I run it. I know that there are rows that satisfy the fields I'm looking for, and can't figure out why matches aren't being found by the report. I don't have a 'who' included for the report, so I'm guessing that's the…
Reporting on the current week
I would like to create a report that would show what needs to be focused on in the current week and I am defining "what" according as follows: 1) Each group of projects (smartsheets) should be bundled into a report; one report for the entire program of projects. Each group has its own report. 2) The individual tasks are…
baseline - actual dates
This post is in regards to this post below. I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.Any help will be appreciatedThanks so muchLouise Jeremy Michels601 ptsApril 5, 2015 8:30 pm I do the added columns now. We use it for both schedule and budget reasons. If you…
Match Formula
Travis, Is there any word on if Smartsheets will have a match formula somewhere in the near future?
Formula Help-Finding the minimum value greater than zero
Hello Smartsheet Community, The formula I used in Microsoft Excel needed to be entered as an array. What is the best way/formula to find the minimum value in a range that is not zero?