-
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.…
-
How to calculate number of cells with dates within the last 15 days?
I'm trying to calculate how many rows on my project sheet have a "completed" status in the "project / task health" column and also have a date in the "completed date" column within the last 15 days. This is the formula I am trying to use: =COUNTIFS([Project / Task Health]:[Project / Task Health], "completed", [Completed…
-
Card View showing Undefined Column
In my sheet, I switch from Grid View to Card View, but the columns don't list out all Owners although each list item has an Owner. Some items are shown under an Undefined column. How can I get the Card View to recognize the Owner names for those appearing in the Undefined column? That way there are columns showing each…
-
Help with Health color formula
I need help with my Health column formulas. I cannot figure out why it's not working. What am I missing? Available health options: Red, Yellow, Green, Gray Health formula: =IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", "Green")), IF(AND(ISBLANK([End…
