-
Populate next Monday
HI! My question is similar to this one: https://community.smartsheet.com/discussion/comment/81401#Comment_81401 I have two date columns (let's call them Date1 and Date2). If the date in the Date1 column is a Tuesday-Sunday I want the date in Date2 to populate with the next Monday. e.g., if Date1 = Tuesday Feb 18 thenโฆ
-
Filter children excluding top summary rows
Is there a way to filter children rows using the green, red and blue balls, excluding the summary rows using above the parent row using the filter feature? Every time I use the filter feature in the Sheet it filters all rows even if I lock the top summary rows.
-
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!
-
Due Date Column. How can i mak ethe dates turn red 5 days before they are due
I used a conditional but it seem swhen the due dates comes up within the 5 days it does not turm red using a conditional. It turns red if i manually put the date into the column cell in the 5 day period
-
Calculated Status Indicator using task duration
Hi, I need to convert a formula that I used in MS Project (see below) to calculate task health status that uses the task duration. Has anyone created a similar formula that they could share? Purpose:ย Highlight tasks that are running late, based on the actual % complete compared to the โexpected completionโ using the taskโฆ
-
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โฆ
-
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โฆ
-
Average Formulas
Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but I'm not getting any output. =AVG(COLLECT([Transit Days]:[Transit Days],โฆ
-
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โฆ