-
Billing Info
Hi, We have recently spotted as license users that we have used 493 of 1300 sheets. Is there a process to increase this 'Sheets Owned' figure or do we not need to worry? Kind regards PMO
-
Dashboard Error
Hi guys, Wondering if anyone can help me out with a Dashboard error i am seeing? I have attached the screenshots relevant. * The error is presenting on a Dashboard which looks up to a Summary Worksheet, which in turn references the core detailed data. * The Chart Type i have selected by default is a Pie Chart (shouldn't…
-
Count Formula
Is there a formula I could use to populate a number into a cell that is a counter of workdays since job has started, and it starts counting once a check box is checked off and stops counting when another check box is checked? this way we can keep an eye on our time frame of a job from start to finish
-
Printing Dashboards - Change to parameters?
Hi all, Has anybody else noticed that Dashboards no longer print at maximum width (i.e. 65% width jammed up against the left hand side) and always seem to have a grey background (even if the background is actually white)? Dashboards used to print really well up until recently, but as per the attached, this is what I'm…
-
Two similar formulas, different results
I am working with two ranges, one contains dates and the other one numbers which I wish to have them added by month such as any number that falls within being >= 01/01/18 but < 02/01/18 gets added. This is what I have thus far: =SUMIF($[Payment Date]$26:$[Payment Date]$35, AND(@cell >= DATE([Due Date]87), @cell < DATE([Due…
-
Best way to Archive Projects
I was wondering if there is a feature for Archiving? And if so can we archive and them bring them back to the workspace at any time? Thank you!
-
Logic Needed for Turning on the Gray Stoplight
I am trying to add logic in the following string that will turn on the "Gray" stop light ball if the % Complete cell is left blank. =IF([% Complete]18 < 0.5, "Red", IF(AND([% Complete]18 >= 0.5, [% Complete]18 < 1), "Yellow", IF([% Complete]19= 1, "Green", IF([% Complete]19= blank, "Gray"))) I have tried "blank" and "null"…
-
Sharing within a Workspace
I have some folders setup in a workspace. In the column 'Sharing' for the folders, it says 'Workspace'. In the 'Workspace Shared To:' list, it shows three users.. Somehow all users can see the items in the folder, not just the three users in the 'workspace shared to' list. How do I restrict these folders? Thanks!
-
Identifying all links in a sheet
Another Smartsheet newbie here...I'm sorting through 25 (ish) sheets and there are multiple links between them. Trying to quickly identify all of the Links In and Links out for each sheet to quickly assess how everything ties together. Is there a quick way to pull this info vs. trolling through each sheet?
-
Link to PDF file on Smart Sheet Form
Hello, Is it possible to make a nice hyperlink for a PDF on my smartsheet form? The current link I have is http://www.DOMAINNAMEHERE.com/mbk/RA Submission - English.pdf My first thought was to put an HTML tag in the form, but that didn't work. When I search the community forum, most of the posts talk about hyperlinks on…
