-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
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" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
When I double click a column header to change the name
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 then seeing what I'm changing the header name to! Is this only happening to me or is this a design flaw that needs to be fixed?
-
Duplicate/repeat column settings
Hi! I tried looking for this question in various ways in the community group, as it seems fairly basic. However, I'm just not finding any keywords that are leading me to the same aspect I'm trying to figure out. Currently, I'm having to create multiple columns that are exactly the same setup - or close enough. I'd love to…
-
Increase the Latest Comment Column Character Limit
The 'Latest Comment' column is a great feature to add the most current information into sheets and reports. It's helpful to be able to provide our executive team printed reports containing all of the information they need. And they don't have to worry about accessing Smartsheet directly. Unfortunately, we recently found…
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
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 (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
Column ID visible in Column Settings
The column ID has been removed from the Column Settings. It is now accessible only through Bridge. I would like to request that it be added back to the Column Settings.
-
Changing / Moving Existing Profile Data - Intake Sheet to Project Sheet
Hi!! We have a large program & want to change where some of our Profile Data fields are being entered without breaking things / renaming fields / doing a ton of avoidable repairs. I'd love some advice on common issues / the best approach! ------- Program Setup (for reference if needed, feel free to skip to the goal 😊) Our…
-
Cannot create "Net Days" column formula
I have a column that auto-populates the number of days left between now and a project launch date. =NETDAYS(TODAY(), [Effective Date]@row) is the formula that I have in the column, and it works when applied row by row. It will not allow me to make it a column formula. Why not?
-
Days of the week symbol in column
It would be cool if there was a column type that was a "days of the week" where it's basically seven dots with S-S and based on the days of the week for that row, either selected in that column or based on a calculation, it would give you a symbol for the days of the week that the row corresponds with. It feels easier to…
-
Multiple columns
Hi How do i add multiple columns at one time, as an example how do I add 50 columns at a time.