-
Sum Collect - not working on new blueprint sheets
I am trying to reference a source sheet on project specific sheets rolled up from a control center blue print. I am using Sum Collect to gather the sum of transactions based on Project number, cost code and category. The Sum Collect formula is working on some sheets, but not others. =IF(Summary@row = 1, "", IF(Children@row…
-
Set automation condition dependent on value in another cell?
I am trying to setup some automation to generate a reminder when the value in one cell (a date) is less than the value of another cell (also a date). I can't use a fixed date as the dates in each cell are different. This is an example of a basic automation script with the condition logic/wording I am wanting shown in…
-
If and AND Formaula
Hi All, I cant get my formula to work :-( Need to say - if Date Paid is more than Required by date then Red and if less than "Green" and if = to then "orange" =IF([Date Paid ]@row > [Required by Date]@row, "Red"), AND(IF([Date Paid ]@row =[Required by Date]@row, "Orange"), AND(IF(Date Paid ]@row < [Required by Date]@row,…
-
Health for Parent Row Based on Health of Child Rows
Hello, I'm in need of some assistance to address the following problem. Objective: I have a series of Tasks which nest into Milestones, and those Milestones then nest into Project Components. I've successfully automated Health for Tasks following a set of desired conditions: I'd now like to automate Health for Milestones…
-
Health for Parent Row Based on Health of Child Rows
Hello, I need some assistance combining the following formulas into a single Column Formula. Formula 1: Successfully automates Health for Tasks based on desired criteria. Should only apply if the row is a Task. Formula 2: Successfully automates Health for Milestones & Project Components based on desired criteria. Should…
-
Combining Text in one column with a URL listed in another column
I have a column of text in one column and a list of URLs in the other. I desire to create a formula to combine the two columns into a third column showing the text as hyperlinked. Example: Column 1 lists Jane Doe. Column 2 lists https:www.janedoe.com Column 3 would be Jane Doe I am looking for a solution or product…
-
Countif on a row of data
Is it possible to count the number of full or blank cells in a ranges of cells, on a single row and have the result in a cell on the row? I've tried countif and Smartsheet wants to use the full row (@row) that leads to circular referencing.
-
List of times for meeting agenda?
I'm building a meeting agenda in a sheet, and I wanted to have a start time as the time portion of a date field, and then add durations for each section. Something like: Section Duration Time Intro 5m 9:00 First Item 10m 9:05 Second Item 1h30m 10:35 I formatted the "Duration" column as the duration field type. I wanted the…
-
I am creating a Sheet Summary that will later be used in a dashboard.
I am creating a Sheet Summary that will later be used in a dashboard. I am trying to sum up the number of calls presented in the month of January that were received by the Info Center and Info Center Callbacks queues. I have the formula =SUMIF([CSQ Name]:[Month], AND(OR(@cell = "Info Center", @cell = "Info Center…
-
How to return the value of another sheet cell, taking into account, values in 2 other cells & sheet?
Hello, I am trying, with a formula, to automatically have a cell checked IF the cell from another sheet is checked too, AND if their ID is the same. Here is my case: I have one "Test Cases" sheet (sheet A). When the tester selects Fail in sheet A, the row is copied to the "Issue List" sheet (sheet B) with an automation…
