- Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
- Cell reference in a notification subject line
Good afternoon, I have a notification action set to send a notification note any time a specific cell is updated. Currently the action seems to allow me to set a standard subject line response something like "Changes to SHEETNAME: Notification". What I would like to do is have the subject line pick up a specific cell so…
- Can I automatically adjust predecessor dates by changing the dependent date?
I'm looking to create a dynamic project schedule with the functionality described below and would appreciate any help from the Community! Our dependent task end date changes rather frequently based on shifting priorities. I would like to change the final dependent end date (in this example, 'swim') to 3 days later (9/10)…
- Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
- IF(OR(Find Statement
I am trying to build a formula that searches in a column for a certain word using FIND( and I would like to add OR to that. I am using this formula and it is working fine: =LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) I would like to add FIND("GZ" so that it returns either after finding "TZ" or "GZ" Thank you!
- Export selected rows only to excel
Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows. Alternatively, is it possible to do a mailmerge via word…
- Formula for Milestone Health
我想找出一个公式"Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
- Keyboard shortcut to insert a new comment
Hi Does anyone know how to open the New Comment dialog using the keyboard? it's becoming more and more difficult for me to take the mouse EXACTLY at the same point and click, in order to add a comment to the currently active row. We sometimes enter comments to update the status of numerous tasks, and this mouse-based…
- Can I hide predecessor lines in a gantt chart?
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but the predecessor lines? Thanks!
- What formula would I use to read a date from another sheet?
I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going…
