-
Select Multiple Values Using IF Formula In MultiSelect Dropdown
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's associated contact has been filled in or not. So for the example below, I would like it to output Project Owner AND Man &…
-
#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?
-
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…
-
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.
-
Old entries to the top?
Hi all, I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, how can I re-arrange these old entries? Thanks.
-
Tracking Created/ Modified and retaining historical data
Hello, I am managing a RAID log which was previously copied from Teams and past into Smartsheet. I'd like to track who and when: created a row modified a row I know those can be automated easily by system columns, however there are some historical data i the already existing columns (creator , created on & modifier,…
