-
Dashboard Charting Problem
Is there a way to exclude cells that have a zero from charting? The bar chart does not show any data, but the topic headers, that have a zero, are cluttering the legend. If there is no data >0, I really would like the legend to not show the headers.
-
How to block the date in a sheet to the creation day only?
Hello everyone! I hope this question has not already been asked, I did not find it on the forum. I have a sheet linked to a form that generates data for me. The form is used by employees and in my sheet the date of creation of a new entry is automatically generated. My problem is that when I "play" in the lines of the…
-
Forms
Is there any way to tell which sheet is being populated by the form url? I have created a form that I shared with colleagues but when they submit the form, I don't see the response in the expected smartsheet, and I dont receive an inapp notification either. I visited the expected sheet to see if I could see the form but…
-
Project Summary to Separate Worksheet
Hello, I am developing a dashboard metrics for a portfolio of project. I would like to know if there is any way we can pull all the project summary details in each project worksheet to a separate one? I know we can do it in report but report has the limitation to add formulas like Countif or Sumif. Kindly advise... Thank…
-
Calculate Duration
I'm new to Smartsheet, and I need help calculating the duration of a project based on estimated start date and estimated completion date. I tried the formula below but it didn't work. =NETWORKDAYS([Due Date]@row,[Date Completed]@row
-
INDEX MATCH MATCH to OTHER WORKSHEET
Hi, I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets. How do I reference the columns as a range and a value? The formula should be as follows: (in cell B2)…
-
Forms - Sending Response to Distribution List
Hello, I am attempting to make a Form that is to be filled out by our customers. Where I have an issue is that the customer would like to receive the form submittal response to their team in a group email of about 40 emails. Is there a way to get the Form to send out the automatic response to a designated distibution list…
-
Date Column
Hello, I have my date column set to 'Text/Number' for the column type, but there is (1) date that keeps reverting back to the actual date format. I've changed this back to Text/Number everyday. Can someone please tell me why this keeps happening everyday? No other dates change except the one highlighted below. Thanks.…
-
Is there a way to create a report from a sheet without sharing any original comments or attachments?
Is there a way to create a report from a sheet without sharing any original comments or attachments? I would like to create a report from a sheet for staff to view without them being able to see the original comments and attachments. Is there a way to do this without having to post it on a dashboard using the report widget?
-
How to loop back information to source sheet.
Hi all, Is there a way to push/copy cell information from one sheet to the source sheet. We have a master record with the master data for all projects. Each project then collects some of the information from the master record including approved budget based on the project ID column to the project template sheets. The…
