I have created a Bug & Issues log for a project I'm working on. Within that sheet I have a column for "Store #". There are many instances where different stores have the same issue and I want to be ab…
I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too l…
Currently it will not let you import anything that exceeds 400 columns. This is very frustrating when your trying to import data into a sheet. I have found myself having to copy & paste the data in by…
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that…
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that…
Hi! The assigned to column works well, and I like seeing everyone's name. However, it would be very helpful to have a "quick indicator" nearer to the project name as to who is assigned this task (or t…
Hi Smartsheet Community, Recently I've been working on a column that allows me to assign required approvals based on certain roles (see below). I want to create a formula that can output an role if it…
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" throu…
When I double click a column header to change the name, a pop up shows up telling me to double click the header to change the name. Not only have I just done the action, the pop up prevents me from th…
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project…