-
greater than or equals to
i need to activate a check box based on the following condition. if date cell A is less than or equal to Todays date and cell b and greater than or equal to todays date then check box. how do i write this please as i can get the formula to work all but the equals to bit. ta blair
-
IF WITH 2 CRITERIA
I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO" I included an image that hopefully clarifies this a little more. in the image I show 3 "A"s in Column2, 2=YES and…
-
If statement to auto link to different cells
On our PM sheet we have stage summaries which show the % complete, start/end date, and a RYG dot. All of this information appears on a dashboard. Currently when we change stages we have to re-link all of the above info to the dashboard but is there a way we can have a formula that automatically links to the corresponding…
-
Cell linking
I have two sheets with several common columns. One of which is closing dates. I want sheet B closing date column to look at sheet A and pull the closing date for each row. The sheets have common columns for lot# which would be the field to index on. In other words, if lot# 1 is closing on 4-1-18 this gets entered into…
-
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
-
sharing permision
Hello, I work for a construction company and we use smartsheet to manage our project and we would like to share a folder without sharing the entire work space thank you :)
-
Card View - Summary Rows & Totals
I'm supper excited about Card View but I can't figure out how to do the summary rows that are presented in the introduction video. Is this a setting? a series of formulas I need to do? do they happen automatically? thanks!! https://help.smartsheet.com/articles/2302238-using-card-view-to-visualize-your-project
-
Start always today's date?
Is there a setting to always have the start date as todays date and the end date does not chang? Thanks in advance. Grant
-
what is the best way to get rid of #DIVIDE BY ZERO ?
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you, Jef
-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…