-
AND not working beyond 2 logical expressions!
Hello I feel like I'm taking crazy pills!!! I have the following formula to change the value of a cell, to encourage the population of cells for a tracking sheet. =IF(AND(ISBLANK(Designer6), ISBLANK([Designer Start]6), ISBLANK([Designer Finish]6), ISBLANK(SME6), ISBLANK(CRE6)), "Pending...", "Click Save to notify!") It…
-
if checkbox
HI, If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected? Regards Stuart
-
Find next / subsequent date in list
Hi, I am stumped. I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column. I am using this formula to find the first date: =IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)
-
Sumifs with Checkboxes
I have a worksheet that I am using for adding event entries in via a form. The entries will check the boxes of the events they want to enter. Each event is a different cost. I want to do a final column for each person entered that will add up each row based on the events given $ amount if the box is checked. Events: PWB…
-
Notification/Reminder for Past Due Task
I have reviewed the many questions asked previously by others regarding Notifications and Reminders as relating to dates and I am either not understanding them or they are different enough from my application that I don't feel the solution is applicable. I am simply attempting to send an e-mail to an individual whenever a…
-
Importing Google Finance Data into Smartsheet?
Hi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…
-
Importing/Syncing Excel File
I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a…
-
Task Constraints
How to you apply constraints on tasks eg. Must finish by, start on etc.
-
Check cell range and compare against date today()
I have looked through and tried to apply several solutions and none seem to work with a range of cells. I have a date/time field column under and have entries in several different collapsible fields. I am in need of help creating a formula that will check all the cells in the range/in the collapsed range (are they children…
-
Formula help
How would i add the children rows, that has the below sum? Grandparent - SUM??? Parent - ="Total: " + COUNTIF(CHILDREN(), 1) Child - Tick box Hope this makes sense.
