-
Issue with Multiple Automation Email's
Hello, I'm trying to implement some automation in a particular sheet and having some issues with email notifications and approvals arriving to my email Inbox. My sheet is set up like so: I am tracking the status of experiments. For a master experiment, there is a subset of children below it. As the children are complete,…
-
Trouble accessing Children rows when filter applied
Hello! I have been having trouble accessing children tasks when a filter is applied. Once the filter is applied and I click the parent + icon, it turns to a - but the children do not show/ will not open. I am also having trouble with another sheet in which I am trying to: add schedule times (preferably to my start date…
-
Resource Allocation : make SUM of working days with multiple resources assigned to task
Here is my issue : TASK1 = [Justin], [Celine] | Duration=10days | %Allocation=20% | [*equivalent to 2 worked-days*] TASK2 = [Celine] | Duration=5days | %Allocation=20% | [*equivalent to 1 worked-day*] I am looking to build a report, or a sheet where i would get : [Justin] = 2 worked-days [Celine] = 3 worked-days [...] =…
-
Populate date when the cell from another column is entered?
Hello! Is there a way to populate a cell in a column with the date another cell (within the same row, but different column) is entered? For example, my company would like the "Date Estimator Assigned" column to auto-populate the date that the "Assigned Estimator" was entered. Thanks!
-
Auto Fill Fields in Sheet
Hello, I have 2 columns I am looking to auto populate based on what is selected in another column. Depending on the requestors name the Manager and Director will populate. The thing I am having trouble with is that multiple requestors are under a manager. I cant get my IF statement to work. Example: Lisa, Doug, and Frank…
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…
-
Getting #unparseable using multiple IF function
Hello Smartsheet community, I have been trying to resolve my error by looking online and this forum, but still can't fix my error. I'm hoping you smart experts can help me. I have 2 columns: Completion Status and Status. The Completion Status has 4 choices: Not Started, In Progress, Delayed, and Complete. The Status has 4…
-
Count open RAID items based off of dropdown menu
I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete. What is wrong with this formula?: =COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)], "Risk", Status:Status, OR(@cell = "New", @cell = "In Progress", @cell = "Requires…
-
RYG Formula Based on Checkbox
Smartsheet Community: I need a little help with this Formula: =IF(Done@row = 1, "Green", IF(Done@row <> 1 "Grey", "Red") I would like to have the row turn Grey if None of the Children Checkbox are Checked, but if one is Checked the Parent is Red until all Children are Check-boxes are Checked. Does anyone have that formula?…
-
How to put formulas in smartsheet form without it automatically override as text?
When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the default value in the form and when after the form has been filled, the formula is exposed…
