-
Date line graph--is this possible?
Hello, I'm trying to figure out how to create something like the image attached. Each point is a project and the dates correspond to the approval of each project. Each dot would have a project name label on it (removed here for privacy). They are horizontally divided by market (each color is a market and label also removed…
-
Do formulas not transfer over to reports?
Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley
-
Copy sheets and references
Hi Everyone! Let's say we have one folder [A] with 3 sheets that have references. If I want to make a copy of this folder (Folder B), I can make save as new and save it...By default, it will keep all the references relative to the newly created sheets. what if I added a new sheet to folder A and I included some references,…
-
Daily report not updating
Hello Smartsheet community, We are currently facing an issue with our daily reports intended to check which deliverables are late. We have a structure with several dashboard for project follow-up, in which we have a deliverable sheet with due dates. Inside of it, we have a formula comparing the TODAY and the due date to…
-
Apply conditional formatting with formula (Need to populate a cell green only if it falls in range o
Dear Team , Need an urgent help . I want to start using the Conditional formatting on only one cell now the complete row . If you see snapshot below , I want to make highlighted cell (Column Jan and Row 3 i.e. 3Jan) to get green if the value is between (Jan2-(10%Jan2), Jan2+(10%Jan2)). Could you please help on this on top…
-
Default value from the dropdown list
Hi Everyone! Here I have a dropdown list of a markup values, how can I set the default value to [15%] whenever I add a new row without the need to do it manually? Also, when the user chooses the Custom Markup option, can I make it in a way that the user enters a specific value after choosing the custom markup option? ( I…
-
Count how many formula questions
Hello All: I'm working on a product development sheet and we have products going live in different months, I created a column that has a drop-down for each month where I select the right month on the product row. The question I want to easily sum how many products we have lined up by month. What would be the easiest way to…
-
Count Unique Cells that meet a certain criteria
I am looking for a formula to count the number of items - "Sales - Service Labour" occur in a series, on unique invoice numbers. I have tried this formula with no success =COUNTIFS(DISTINCT([Invoice Number]:[Invoice Number]), Account:Account, "Sales - Service/Labour")
-
Convert High, Medium, Low to numbers (without nested IF statements)?
For each row in a sheet, I need to convert High/Medium/Low IMPACT and EFFORT text into numeric scores like the table below. I know I can do this with nested IF statements, but was able to do this much more simply in google sheets using VLOOKUP or CHOOSE functions: =VLOOKUP(M4,{"Low",1;"Medium",2;"High",2},2,FALSE) /…
-
Can we have fourmola to find amount of changes from a specific user, for specific column?
Hi There, I have a smartsheet that has multiple columns, including a column of assigned users, is there a fourmola to check how many changes a specific user made to this column today? Please help out. Thank you in advance!
