Here in the "PM Name" column, I have a value which is of Contact type. I tried copying the value over to the next column, then i get the Email address Prefixed by my name(Manasa M S<manasa@gmail.com>).In the next column I want to extract only the email address(eg: manasa@gmail.com). please share if you have formula for…
Hello, I have a little bit complicated issue, because I would like to copy the row once the criteria date column changes to any value, but I would like to add additional criteria , that the system need to check the previous value , and if its equal with the current one, then no need to copy . Unfortunately the system copy…
Hi, I am not sure if this is possible but what I am looking to do is. I have 125 custom flanges in stock I have a shipment of 100 custom flanges due on the 24/4/23 I have used 25 custom flanges in order 01 However, the stock of custom flanges is now 200 which is not true because the shipment hasn't arrived yet. What I am…
There doesn't seem to be any native functionality to reschedule remaining work when planned finish dates are missed - a MAJOR flaw if true. Am I missing something or does anyone know of a work-around?
I'm trying to pull certain data from a test reference data sheet into a calculation sheet to later summarize for a dashboard. Here is my test reference data sheet I want to ask the question for the second column (also called "Range 1) IF the text "Jan 2023" appears in one of the cells in this column to return the "Title"…
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
I have a smartsheet that was not designed by me but need to manage the sheet. I have the following formula that takes a value in May-2022 and in %Util to produce a new value as a %. I don't understand what # does at the end of the formula? =[May-2022]@row / ([%Util]@row * [May-2022]#)
I am trying to create a metric sheet. I'm looking for a count of all Backlog items by team member; multiple team members can be assigned to an item however I'm looking at individual metrics. I can get the formula to work when the name is the single name in the Responsible column but not if there are more. Here's my…
Hello, I am trying to resolve a formula to calculate a total score in a form for weighted values based on selected criteria. It works in excel when I create a table but not working in smartsheet form and getting #unparseable error. I have 5 criteria each with 5 option to select from. Each option returns a weighted value to…
I'm trying to write this formula using index and match to reference sheets. The indexed columns are checkbox columns. 0 = not checked 1 = checked IF INDEX & MATCH A = 1, Then "ORDER" IF INDEX & MATCH A = 1 AND OR INDEX & MATCH B = 1, INDEX & MATCH C = 1, Then "ORDER & EMAIL" IF INDEX & MATCH A = 0 AND OR INDEX & MATCH B =…
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
i need a formula to find todays date between the start date and end date, then provide the current sprint