-
Help with if max collect formula
Hello, Sorry I know there are already questions on this but I'm not getting it. I have a column [Users] of duplicate users, and a second column with unique numbers [Row ID] In a third column I am trying to get "Ignore" or "Select" based on the highest number per user So in the example above the PCUK832 should say ignore…
-
Is there a better way to write a formula that collects data for each week of the year?
Hello This is my current formula. It works but is laborious to write out. Is there a better way? =COUNTIFS({CBTC Feeder File Range 2}, >=DATE(2020, 6, 1), {CBTC Feeder File Range 2}, <=DATE(2020, 6, 7), {CBTC Feeder File Range 1}, FIND("ITAV", @cell) > 0)
-
View Cell History - Forms - Created by: User
Hi, Currently, when submiting a from, it says in cell history "Created by: User" Is there a way to view info. from the one who submitted a form, in the view cell history in smartsheet? Maybe it should say the name, taking it from the name section on the form etc. Thank you!
-
How can i create a master sheet from separate sheets?
i want to create a masters sheet for a general over view of projects in the pipe line Sheet 1. Sales this will have customer info, size of job and a fee key points of the project sheet 2. project management, who is contracted what we need to traack sheet 3 owner billing sheet 4 sub billing master sheet would take job…
-
Form - Branding
Hello, How do I add my logo to the Smartsheet update form? See attached for example.
-
Column name not coming over in report
When creating a report, I have a column named "Filled By" its configured as a modified by column. In the report, the naming for the column is Modified By in the report, but I want it to say "Filled By" because thats what it is called in the sheet. Is there a way to correct this?
-
Bubble Chart-Scatter Chart
I've been requested my by executives to create a bubble chart of all the projects in the pipeline to gain a better understanding of priority . The chart will have 4 quadrants, see the attached. I have created columns in my smartsheet project list so the dashboard once completed can pull this data from. How do I get started…
-
Report Builder
We are experiencing issues with the new report structure. On one of our dashboards, the report wasn't working. It's only showing 1 filter. The other 2 filters set up show up with the info but t hey are rimmed in red. A message shows up about completing the filter criteria. You can see that I confirmed it for Parent Row…
-
Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard
I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of…
-
Showing delivered milestones in dashboard?
Hi all, How do I make my dashboard on a project show which milestones have been delivered since xx date, previous month or similar? I have a owner keen on knowing this in Dashboard, but can't seem to find the right solution. In advance, thank you for feedback. Regards Lise