-
Cell Value Minus -? Is this possible in Smartsheet
I am working on a pretty massive data sheet and I have 4 years that are broken down by Months and then by Days of the Week. =SUMIFS({Resources_Required Data}, {Group_Name}, $[Primary Column]$197, {Weather Data}, $[Primary Column]$214, {Day of Week Data}, $[Primary Column]215, {ADD_TIMESTAMP Data}, >=DATE(2016, 1, 1),…
-
Nesting Parent(Parent())? Is that a thing?
I had a super long post but I'm finding that the people who tend to respond are people who want to be hired as consultants. I'm not really interested in that, so I figured out my own issues the best way I could. :) I've got myself to this point =SUMIFS({Resources_Required Data}, {Group_Name}, {Group 3}, {Weather Data},…
-
Report Features
Hi, may I know can I add any bar or pie chart and customize the design of the smart sheet report just like the widget in the dashboard? Thank you.
-
Smartsheet loading blank page
Is anyone else getting a blank page when they log into Smartsheet? I get the blue bar at the top but nothing else.
-
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…