-
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.
-
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,…
-
Sheet Calculations are not copying
I have a complex sheet where users are entering data from a form and the sheet should be making a series of calculations. Each entry should be the next row (e.g. form enters to the next in in series) and then as the work is completed the process is updated on the sheet. It seems though each row is blank, the calculated…
-
If the column you are trying to delete is used in a formula then you see a message
If the row or column I am trying to delete is used in another sheet or referenced in a formula within the same sheet then I want to see a message pop up saying the same. This will prevent other sheets, reports, dashboards from getting messed up without me having to manually track all my references.
