- Counting Past Due Task
Is there a way to count past due tasks in Smartsheet? I would prefer to count based off of the finish date, but cannot seem to get the formula to work. I am fairly new with the software, so any recommendations would be great! Please let me know. -Branden
- VLOOKUP Annoyance
Does anybody know if there is a way to rid of this annoying fly-out when viewing a sheet that has some references in it?
- If and Vlookup
I'm new to Smartsheets and I'm trying to figure out how to do an IF([Response]3="Yes", VLookup formula linked to a reference data sheet. I've tried various ways to input and always get Unparseable. Any help is appreciated!
- Formula to reference cell in another sheet?
Hi, I'm wondering if it's possible to reference a cell in a different sheet with a formula. My source sheet is intended for users to add entries, and my destination sheet is intended to keep track of when the source sheet was last updated. Because entries are added to the source sheet, and I always want the newest date on…
- Referencing % in Formula in Symbol Column (RYG)
Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IF formula referencing cell formatted to %. When I replace the % with any text and update formula to reflect the change, the correct RYG symbol is displayed. When I attempt to reference…
- Formula Question
Hi There. I have a sheet, very much like a project tracking sheet, with a few adjustments. I have a start date / due date / completion date, as well as a status column. I would like to create a column that has green/yellow/red dot based on the status being not started or in progress AND relative to the due date. We have…
- Calendar Schedule
I'm a new smartsheet user. I'm curious if I'm able to make a sheet, that pulls data from 4 columns and puts the info into Calendar View either to be displayed onto google calendar or on smartsheet calendar. Driver Name: Location: Date: Time: Any help appreciated!
- 如何返回日期基于numerical value?
Hi Smartsheets Community, I have 12 columns that each represent one month and in those columns there are numbers (not dates). Every month I will enter that month's financial data. I want to write a formula that tells me which month was the last month to be updated and I want it to return that month's date (vs. a text value…
- IF formula for Status of Child
Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child tasks have any other status).
- Utilizing IF to open different sheet upon condition
Hello everyone, I have been googling this for a while, and decided it would just be easier to sign up for the forums and post my question. What I am trying to do should be a simple IF function statement whereas if a dropdown list entry is hit in a cell, then the user is pointed to another sheet. e.g. Dropdown box 1 on…
