-
Random Email ID shown during Mouse over in Resource report?
Hi all, Anyone know what the email address is referring to when mousing over the (over) allocation in a resource report? It is not the email address of the resource (Hue in this case) Thanks ahead of time! -dp-
-
how to use resource views and resource management without being a system admin
Hi all, I would like to manage my projects from resource views, but I can not enable this feature (enterprise plan). I am not the system admin. Is it it possible that he could give me the rights to manage my resources and views? Thanks
-
Print Scaling Inconsistent
I have 2 separate reports. The first report is 44 rows in length. From smartsheets, when I print the report and use the Fit to Width function, the report is 1 page wide by 1 page long. This report has 16 detail columns. The second report is 37 rows in length. When I print and use the Fit to Width function, the report is 1…
-
Connecting two Templates with formulas
I have a group of sheets that i have created templates for. I was wondering if there was anyway to have the formulas in the sheets not break when templates are created and to point at each other instead of having to be redirected every time a template is used. Ex: Sheet 1, 2, & 3 all point to each other. I have added all…
-
Smartsheet SME's
Are there any Smartsheet SME's on this board that are interested in providing some paid advisory support? I would be looking for someone who understands the nuances, best practices of setting up Smartsheets, developing reports, workflows and dashboards. Or, if you know someone outside this forum? Thank you in advance for…
-
Age
How do I create a formula to automatically calculate the age? I currently have this formula: =(Date of Birth-Current Date)/365.25
-
Update a line via form without rights to view the sheet
Hi, I have a list of adresses and would like to send an update request but without giving this person the rights to view the whole sheet. Any ideas how to make this? Thanks, Joachim
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Due Dates that exclude weekends and Holidays
I need a formula that will return a date that does not include weekends or holidays. For example: Notification Date 1/18/19 Due Date (formula that counts 20 business days from the notification date and excludes holidays). It should return 2/16/19 because MLK day is on Monday)
-
Glitches / Mixed up rows
There have been a handful of occasions now where we load Smartsheet and it looks nothing like it should. Rows get mixed up with no pattern to discern why. Luckily, I had someone take screen shots of what it looked liked before so we could straighten it out. But I need answers. Smartsheet is a great product, and so forth,…
