-
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
-
Use index that make dynamic formuale in the row.
I am trying to replicate an Excel dynamic sum in Smartsheet. I have a row containing data for weeks 1 through 52. I want to sum the values starting from the current week (based on today's date) through week 52. In Excel, I used a dynamic range, but Smartsheet is giving me an error. How can I sum a specific horizontal range…
-
Creating a formula to calculate Created Date column - not working correctly
If I am trying to create a metric formula to count how many rows were created today, created yesterday, created 3 days ago etc… by using the auto "Created Date" column. The current formula I am using is not properly adding them correctly =COUNTIFS({Ticket Tracker Range 1}, "COUNTING" , {Ticket Tracker Range 3}, =TODAY(-1))…
-
Table View - Show column links AND formula in row header
Currently, if there is a formula in a column and the data is part of a column link where that formula data is being sent elsewhere, the column only shows the Column Link icon… and doesnt show the formula icon. It gave me a minor heart attack today!!
-
Overall Project Health Based on Health of Milestones
We use the WBS for our project plans and indicate milestones by setting the duration to 0 and the start and end date as being equal. Our current column formula is =IF(ISBLANK([Start Date]@row ), "", IFERROR((IF(OR([Start Date]@row = "", [Start Date]@row > TODAY()), "Gray", IF(OR([% Complete]@row = 1, [End Date]@row >…
-
Dashboard Pulling Week# and Year
Hello, We created a dashboard last year that pulled data from the week number but now that it's a new year, the data isn't pulling correctly. We added a year column, but haven't quite figured out how to do it correctly. Any help? Does this look correct? =COUNTIFS(WEEKNUMBER({PrintProductIntake-Week#}, [Primary Column]@row…
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…
-
Help with cross sheet lookup
Hello, In my source sheet I have a multiselect column called "Problem Code to be Updated". I am trying to use the reference sheet in the screenshot to identify if the multiselect cell in the source sheet has any of the problem codes where the "Technician Assigned Problem Code" is "Yes". The dropdown values are all taken…
-
Index Match with Varying Match Criteria
I am trying to do an Index Match where I have multiple lookup values in the same cell. I want it to grab all available App Names and return/concatenate them into the cell here. I have some App IDs with just one # where it works fine normally but others like the example above have multiple listed.
-
Complicated IF statement
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…