-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
-
Convert Variance in project sheet to weeks
Hi I'm using 5 days a week in my project sheets and I want to convert the variance column into weeks baseline in weeks in working out the duration between the baselines dates (please ignore) please can you advise the best way? @Paul Newcome @jmyzk_cloudsmart_jp @Matt Lynn-PCG
-
Calculating past date from a January Birthday
I thought I had this all figured out a while back, until diving back in now I notice that a handful of my dates are not working correctly. I figured out it is all of the rows where the person has a birthday in the first couple weeks of January. I want to take the birthday and create a date range that a survey can be…
-
collecting all comments in one cell?
Hi there, I am trying to collect all comments in to one cell following these formulas: =JOIN(COLLECT({Comments}, {Row ID},[RowID]@row)) =JOIN(COLLECT({Comment Only}, {Row ID}, [Row ID]@row), CHAR(10)) Example explaining it: a way to collect all comments in one cell - Smartsheet.com however, it keeps giving me #UNPARSEABLE…
-
Countifs for removing duplicates using multiple criterion
Any suggestions on how to flag duplicates based on the following: -Would like to flag items with "NO" in the Evaluated Column if the Vendor also has an Evaluated "YES" for that item number. In example below, highlighted SAG data would flag the "NO" line (the vendor "SAG" has two entries for "Item Number" 1- a "YES" and a…
-
Sum(IF(ISDATE
Can this statement work. Getting a syntax issue. =IF(ISDATE([Plans To Field Date]@row]@row), Sum(IF(ISdate([Slab Inspection]@row), 1, 0), IF(ISDATE([Frame Inspection Date]@row), 1, 0), IF(ISDATE([Cabinet Install Date]@row), 1, 0), IF(ISDATE([Final C.O. Date]@row, 1, 0) + 7)), SUM(IF(ISDATE([Spec Release Date]@row), 1, 0),…
-
How to create an "Update Employee Information" form or integration w/o sheet access
Okay, I'm going to try and explain this and hopefully it makes sense. I have begun creation of a workapp to integrate all the various tools we need as a company to onboard employees and I've run into a wall with one aspect. First of all, i am creating this so that all the dozens and dozens of hiring managers in the company…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
Create master list sheet for multiple individual sheets and count the data from individual sheets
Hi there I have a question to how to automatically link the count formula from one master list to individual sheet. Below is my workflow. I have created multiple individual sheets for each of my program to track the program status, (Pink Heading) Sheet 1 - Program 123, Sheet 2 - Program 124 … Then, I created a (Blue…
-
Help with Dates
Hi, I've got this formula below and I'm very confused why it spits out 1 rather than 0 as I believe 12/29/2024 is less than 1/5/25. Is it because it's parsing it as DDMMYYYY rather than MMDDYYYY? I feel like that's probably not the case since 12/29/2024 would spit out an error if the format was supposed to be DDMMYYYY.…