Discussion List
List of Same Project name with unique date.
I have four column as show in table below columns. I have one text/number column two date and one duration. "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of…
what is the best way to combine contacts from children rows into parent row?
In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)
Index collect from
I have 2 sheets I am working on with; Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record…
Sheet Summary Data not syncing on my Dashboard
My sheet summary data is not updating in the widget on my Dashboard. What makes it even weirder is that part of the sheet summary information from the same sheet will update, but another part of it will not. How can I fix this? Is there a known issue with this?
Unable to get the formula correct to merge my data from multiple columns into one column.
Is there a demo version where I can review document builder and docusign?
Automation Workflow Not Triggering
Hello, Does anyone have any suggestions on how to fix this issue? It seems after I've entered more data in the sheet, the triggers stopped working and I'm not receiving any emails at all. I didn't change the triggers when they used to work and only entered more data in the sheet. I've also sent a ticket to Smartsheet IT…
Formula Needed. - IF Blank, then Index another cell
Hi, I am looking for some help with a formula. I need a formula that will "pull/copy" the date entered in the column titled REV. START DATE. However, if the REV. START DATE is blank, then I need it to pull the date from the ORIGINAL START DATE column located on the same row. I was originally using the =MAX([Original Start…
Need formula for identifying whether a task is a subtask (regardless of overall task level)
Hello, I have a project plan that has 6 levels and am looking for a formula that will identify, in a separate text column, whether or not a task is a subtask regardless of what level it is at. (So only that the subtask is a lower level than its parent task and not that it is at a specific level) As an example, I would need…
Automation workflow restriction
Hi, I have a sheet, which I do not want to share with my team members (and the information is fed into this when these submit via form), but wanted to include them in workflows to receive automated email alerts. These Automation permission settings cannot be changed (already contacted system admin). Is there any other way…