-
Building Metrics based off report data
Is there any way (I do not think there is) to add metrics on a dashboard based on results in reports? OR To show the summary view in a report on dashboards. If not I can add a feature request.
-
Reports based off Folder
We have an "Active Projects" folder. Is there not a way to auto add a sheet to a report that is placed in that folder? Currently, I have to go to the reports, select the folder to ensure it's all added. Is there any way to do this?
-
How to make a column number not exceed another column's
I have a column called "Days worked", which I get using: =IF(NETWORKDAY([Start date]@row; TODAY()) < 0; 0; NETWORKDAY([Start date]@row; TODAY())) This ensures it won't go below 0. I want to also make sure it doesn't exceed the number in a column called "Duration". I tried combining the aforementioned IF with :…
-
Number lower than 0 to show 0 using IF
I have a column called "Days worked", which I get using: =NETWORKDAY([Start date]143; TODAY()). I use this for all tasks, including future. Therefore it shows a negative number when it is a future project that has not started yet. I want it instead to say 0. I tried with: =NETWORKDAY([Start date]143; TODAY()), IF([Days…
-
Notification except if attachment are available
I want to be able to automate notification to certain users in case a row is modified, but only if this row does not have an attachment. How can I do it? I tried adding a condition to the trigger for notification, but the field "attachment" is not there, so I can't put a condition on the presence/absence of attachment. Any…
-
Pivot App- Error! Column titles are not unique among input columns. (1133)
Can you help me? I run to this error when doing a Pivot. Thanks.
-
Copying rows and the display of gantt chart
Hello Everyone For context: I am using a sheet where I have 2 date columns, but only one is populated, "Sign in Date", the second one (Sign out Date), will only be populated when a person is signed off. And that is only for the purpose to copy that row to secondary sheet. When row is copied, then dates, names(primary) etc.…
-
Best way to display product information
I am creating a master sheet with information from several different cross functional teams, including dimensions, features, product images, product availability date, etc. We are at about 175 columns total at the moment, and as you can imagine, finding information is time consuming. I'd like for people to be able to…
-
Is there a way to download SmartSheet form as a PDF?
I want to be able to use Smartsheet form as a PDF also in cases where I have to manually write information or use the form as a Job Sheet for Complaint/Servicing form. How can I do that? Any help will be greatly appreciated.
-
Dynamic Drop Down lists from another column either within the sheet or from another sheet
I've searched, but everyone seems to say that this is not an option at the moment, are there any work arounds? I want to create a page where someone can create a product id number based on several factors, i.e. category, model number, color, country, end customer I'f like osmeone to be able to select the category (call it…
