-
Join Collect Formula with Contains?
Trying to figure out the following formula but am having trouble getting it to work: =JOIN(COLLECT({GHL Maintenance Range 1}, {GHL Maintenance Range 2}, CONTAINS([User Email]@row), ", ")) Basically trying to a join collect which is simple enough, but I want it to count if the user email is Contained in a cell where there…
-
trying to edit / change a formula to reference different columns
Need to change my column “Expected % Complete” to reference the “Actual Start Date” and “Actual End Date” columns (and not the “planned start date/planned end date columns”) When I try to replace the column references, I get an “UNPARSED” error Change from this: =IF(TODAY() > [Planned End Date (original)]@row, 1,…
-
Our "Record a date" workflow is causing side effects
We use Automation quite extensively and have just set up a "Record a date" action. But, when it fires, a number of adjacent rows change the values that show in their [Task Status] which is most unexpected, and they return to their correct values after a refresh! Additionally, the automation seems to fire erratically -…
-
VLOOKUP Doesn't Appear To Work With Auto-Number Columns/Cells
I have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track projects tasks and want to be able to link a task to its associated project in the project sheet. There are select columns…
-
Help converting a time formula in Excel to SmartSheet
I have an Excel spreadsheet with a column called Set times, an example value being - 6:30am > 6:45am (00:15 total) This value is unchangeable because it is exported like this from another program and is unchangeable. I have two more columns in Excel, called Time IN and Time Out The formula for Time In is -…
-
can one trigger still be used to trigger multiple conditions in a conditional path ?
I have a trigger that is setup to notify assigned contacts across multiple different columns, but I am finding the trigger only works on first condition and then does not continue to work on the rest of the additional conditions . I used the 'conditional path' to create the conditions below the 'trigger ' but seems to work…
-
Help w/ IF OR formula
Hi team - I have a formula that is working for 90% of my selections. I column called Type with the following drop down options: 1st Line Control Testing 1st Line Management Identified 2nd Line Compliance Self-Identified Audit Identified Compliance Identified Compliance Testing DE Assessment Identified ECORT-IT Risk…
-
Concatenate instead of adding days from a date?
Hi, I am trying to add days from a date, depending on the value of another cell. Instead of adding the days it appears to be concatenating. In the screen shot below the desired result would be an Expected Sample Date of 04/01/21. Instead it is displaying 03/01/2132. Here are the Columns I am using: Completed in Lab Date…
-
Have 1 cell populate another
I have SHEET A and SHEET B; on each, there is a column LAST_NAME. Is there any way to have SHEET B be populated when SHEET A is filled in? In other words, if someone enters "SMITH" in the LAST_NAME column of SHEET A, I would love to see it automatically populate the LAST_NAME cell in SHEET B. Please advise and thanks in…
-
Can I count the status in a projectplan, to directly display on the dashboard?
Hi all, I would like to include in a dashboard, the count of each 'status' in a projectplan and the percentage of that status appearing in the plan. I can do that with a countif(), but THEN I need to make a report, to be able to display it in a dashboard. Is there a way to get it directly in the dashboard, or with a…