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 pe…
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." How…
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…
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 'goo…
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 (US…
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 the…
Good afternoon, I need to create a form to measure Net Promoter Score (NPS) for our PMO office. I have samples for the questions, but I would like to know if anyone has experience building a form spec…
Hi Team, Can someone help me how to create a report that doesn't require to manually add when we have multiple projects...Is there a way.? Regards, Tanveer
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the oth…
