-
Project Health Formula
I am trying to get this formula to work on my project timeline. But keep getting #UNPARSEABLE. =IF(OR(Status@row = "Not Started", [Target End Date]@row >= TODAY()), "Green","Yellow",IF(OR(Status@row = "In Progress", [Target End Date]@row >= TODAY()), "Green","Yellow",IF(AND(Status@row = "In Progress", [Target End Date]@row…
-
How can I add a trend line in a bar graph?
Hello All, I have recently started using Smartsheet and have been on YouTube and this amazing forum to self teach. I have a couple of questions which I hope I can get answers for I have bar chart made with 6 bars. Am I able to add a trend line into this? I would ideally like to represent where we should be as opposed to…
-
Form fields to include Comments
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
-
COUNTIFS values from multi-select cell and account for date range
Hi - I'm having trouble counting a specific value (text) from a dropdown list and referencing a date range that corresponds to the row. Any suggestions on the right formula to use? I've played around with the COUNTM, HAS, and CONTAINS formulas but have not been able to achieve what I would like to see. For example, my HAS…
-
Copy Rows Error Message
Hi I am trying to copy some rows to another sheet and I get the below error message. Any help appreciated, Thanks
-
Formula for changing symbol colors
I created a column that changes symbol colors depending on the start date column. The below formula I put together after reading through some other posts within this community works alright except for the bit to have the symbol change to gray when the start date is today or past. What am I missing? =IF([Start Date…
-
Average Days from Days Opened formula
I have a formula in a column for the number of a days a ticket has been opened. =IF(Status@row <> "Completed", TODAY() - [Created Date]@row, "") I want to add a metric in the sheet summary to tell me the average days of open tickets. I am using =ROUND(AVG([Days Opened]:[Days Opened], 1)), but this is accounting for closed…
-
Pulling Information into another sheet
I am trying to pull "Project Name" and Project ID" from our intake sheet into our Project Medtadata sheet. I tried using a formula but doesn't seem to work. Here's what I used. =INDEX(Portfolio:Portfolio[Project ID], MATCH([@Project Name], Portfolio:Portfolio[Project Name], 0))
-
When creating a form with dropdowns, can I limit dropdown selection based on previous question?
I have a form link being sent daily via automation. I have a column with Facility Name (currently only 10 names). I want this field to prepopulate based on the response from the previous question. Is this possible?
-
Progress Bar Automation between 2 Different Sheets
Hi to all you brilliant Smartsheet Wizards! 🧙♂️🧙♀️ I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from…
