-
Calendar Display Column
How can I change which column is displayed on my calendar?
-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!
-
Pivot tables grouping
In excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?
-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…
-
Locking Hierarchy
Even if I lock parent rows, users I've shared my Smartsheet with are able to expand and collapse child rows. Is there a way for me to prevent that?
-
COUNTIFS of a text string based on a condition
I have two text columns. One column contains titles of documents. The second column contains specifies the document's "category." One of the categories in the "Category" column is "Presentations." However, in that category are two different types of presentation: "BDM" and "TDM". Whether a document is a BDM or TDM is…
-
Auto send a completed form to an email address
Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields in the form when it is completed, however everytime the form is created I have to type…
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
Is there a way to limit the max number of characters in a text/number field?
I have a form that I want to use to capture telephone info. Is there a way to limit the max number of characters that can be input in a cell and perhaps show an error message to the user? Also, is there a way to limit input to numerical text only? Thanks. Bill
