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
Countif with dates
I have a column of dates. I want to have a single cell on a different column that tells me how many of those dates are in the past. I have tried to use Countif(column9;column109, "<=Today(0)") with no luck. All help appreciated.
Feature Request: Toggle on/off a Report Builder search parameter
What I would like to be able to do is toggle on/off search parameters in the Report Builder for a given report. I have a report which I use daily. There is a search parameter I which I want to be able to activate and de-active to get a certain view of the report. For example, I embed a keyword/tag in the Primary column…
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!
PM's with multiple types of projects - approach?
team of 5 people, with four project types. - think new, inline, market research, and outreach. would you have a sheet template for each project type, and make a new sheet for each project, or one master sheet for each personwith a "project type" drop down or some other way? The projects have aboout 25% overalpping data and…
Sheet Title in a cell
Is there a way to pull the sheet title into a cell within the sheet?
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
Conditional Link/sheet
Good day, I am a user of Smartsheet and am wondering if you guys can assist. First I will try to draw your kind attention to the task I would like to do in smartsheet, as below: Sheet 1 ITEM DESC COST1 COST2 BCOST DATE PERCENTAGE AA WOOD £12.00 £13.00 £12.50 12/4/16 12% CC FOOD £15.00 £11.00 £12.50 12/4/16 9% Sheet 2 ITEM…
Change cell text depending on other column
I want to change the text in a cell dependant from an other column. For example: the column % complete has changed to 100% then the text in the status cell changed to 'Complete'. The conditional formatting is just for changing background and text colours not to change text in cells.
Automate Reminder to my team for sheet updates every Friday
How do I do this? T
Shared To Me and grouping sheets/workspaces
Right now I have about two dozen sheets shared to me. That number is about to significantly increase... because the people that are sharing the sheets with me work on different projects, is there a way to "view" or "group" my shared sheets other than by clicking on the Location or Owner header to sort? Say, one group for a…
