-
Number less than zero is shown as a zero
Hello again community, I am hoping someone can help me understand the right way to write this formula for what I am trying to achieve. I am wanting to subtract one cell from another which in some cases provides a negative number. I would like the formula to pick up on this negative number and output a 0 in place of the…
-
Reports
Hi, Recently I create an report file, where I want him to show certain columns. I choose for "Where" condition the location from where i want him to extract the info. But if i will create another new sheet in that folder, even the entire folder is choosen for report, he dosn/t know to automatic include that new sheet in my…
-
Time off on a per resource level
Hi everyone Is it possible to set the time off (holiday, edit) at the resource level and have it reflected in the project plan? Thanks, in advance, for any guidance. Lloyd
-
Restrict access to a web form
Hello , I would like to embed a web form to a portal shared to many users , like in the pic . How can I manage to restrict access to this web form only to a few users ? Thank you in advance .
-
Activity Tracker
Hi, I have lots of sheets with different stakeholders who update these sheets, I want to check which row items have not been updated after their due date or Actual End date. How can I schedule report like that?
-
Dashboard: Loss of images that existed on my report
In our Smartsheet set up, we provide photos of users that appear with their name (in assigned tos, owners, etc). These photos will appear in sheets, reports, etc. However, when we use a given report or data source in a dashboard, the image/photo is removed. Is this a known issue or is there a setting/checkbox we need to…
-
Report Filter not Filtering properly
Hello, I am trying to filter out certain values in a column from a report and up until today, it was working fine. However, now when I change the value in the field for that column for a specific row (and save the update, and verify it saved to the primary sheet, and I refreshed multiple times and closed all browsers and…
-
Print Workflows
Is there a way to print out the automated workflow I created so I can review it with my team on paper during the roll out?
-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Goto line ...
Hello community, I have a smartsheet with 5000+ rows. I would like to find a way to automatically Go To line 2000 (and not scrolling down). Is there some "GoTo" hyperlink I can create ? How shall I do this ? Best,
