-
Cell Value Capture for Monthly Reporting
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy automation however i need to build a "capture sheet" for the dashboard to reference for several data points (total invoice…
-
Creating a count for a Column
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working and I am not the best with them. Can someone help me figure this our?
-
Solution for copying a Contact List column to another Contact List Column
Hello, I am trying to figure out a way to copy a contact from one column over to another column (both columns are Contact List) in the same sheet whenever someone selects "Yes" for a seperate column asking if the Reporter is the same as the Risk Response Owner. If someone selects yes, I would like for the person identified…
-
Formula is not working Smartsheet, Same formula worked perfectly fine in Excel
IF(ISNUMBER(SEARCH("text", cell)), value_to_return,"") Can someone please help me to understand why these formula is not working in Smartsheet.
-
IF/AND/OR Formula for Parent Row
Hello! I'm looking for help to perform the following logic for Parent rows ONLY: If the status of any child row is In Progress, then set the parent row status to In Progress. If the status of ALL child rows is Complete, then set the parent row status to Complete If the status of ALL child rows is Not Started or Blank, then…
-
Errors with Status Ball Formula
Appreciate any/all help! I can’t get past errors: #UNPARSEABLE, #INVALID DATA TYPE, #INCORRECT ARGUMENT SET I'd like to achieve the symbol results in the "Indicator" column based upon entries in "Client Status" and "RCM Status" columns. Thank you! Mary
-
Calculate Age from birthdate
Is there a way to have a cell auto calculate age (years and months) from birth date in another cell?
-
AutoNumber Parent Rows Only
Is there a formula/ methodology to auto number parent rows only, preferably with a prefix style numbering sequence like the Autonumber column type uses?
-
Appointment Scheduler Workapp
I have a requirement where I need customers to book appointments for us to send a technician to their site. We have multiple technicians available but still want to avoid double-booking in the case all technicians are booked on a given day. I've seen similar questions posted before, but none with detailed answers and I am…
-
IF Statement with multiple dates an count.
Hello, I have a large sheet that I am trying to calculate several dates to populate dependent on a Count in a row field (ie - a count of 0 would generate a date being pulled from one column, and a count of one generating a date from another column). Columns in Question: "Was Rejected" - this is a count on either it has…