-
Reference main table to populate a new subset table based on conditions
Hi, I created a workspace that contains a list of project folders (and its respective sheets, reports and dashboards). I'm looking to produce a new consolidated Master sheet based on multiple criteria from each main reference sheet found in the workspace. In the simplified example attached, the new master table must be…
-
Flag By Issue Status Formlua
This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open" This is what I'm using and getting an unparseable =IF(Issue@row = Open, 1,0) Thanks in advance!
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
Alert notification are not sent anymore
From beginning of the week all alerts form my smart sheet are not sent anymore. I have not change any workflow settings. last week everything was ok. I have the same problem on my all smart sheets. Please help. Attached workflow
-
Delta/Slippage Formula
I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Change Order (CO) Days that are populating dates and numbers with cell linking from the…
-
Applying new template sheet to old projects
We have a collection of projects that were created some time ago. Since the projects were created, the blueprint those projects were based on have had some additional template sheets added. Is there a way to incorporate those new template sheets into the old projects, either on a single project by project basis or in bulk…
-
Question on showing text (comments) from cells in dashboard
Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type in comments about the material. Is there a way (possibly through a report?) to have a widget that shows comments people…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Glitches / Mixed up rows
There have been a handful of occasions now where we load Smartsheet and it looks nothing like it should. Rows get mixed up with no pattern to discern why. Luckily, I had someone take screen shots of what it looked liked before so we could straighten it out. But I need answers. Smartsheet is a great product, and so forth,…