-
Alerts & Actions
I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request would be emailed to the contact in "Sales Rep" column and copy (cc) me in the emailed Update Request for all of them. I was told…
-
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