-
Formula for Gantt Progress
Hopefully I can explain what I'm trying to accomplish here... When using the Project Template, SmartSheet shows the % complete overlaid on top of the duration bar in the Gantt Chart. Right now we're using colored icons to indicate whether a task is on target for completion (the progress bar is ahead of the "today" dashed…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
-
Formula range extends to include new rows/entries. Sheet Summary
I'm using Sheet Summary to sum amounts on a sheet where new entries are occasionally added via forms. I want the new entries to be included in the range of cells summed, but that's not happening. Any tips?
-
Formula for tasks/Sheet Summary
So I'm at another roadblock so bare with me... I have a current formula that tracks the prior day's target tasks and a formula that tracks the prior day's completed tasks. However I want to incorporate my overdue tasks in these formulas as they still need to be accounted for. I was able to add my overdue tasks to my daily…
-
Nested If Or to control symbol
Hi All, I'm trying to set a symbol (Red, Yellow, Green) in a column based on the individual values in three columns. We'll call the columns the contain the values "Carrots Available", "Fudge Available". and "Veal Available" and the column with the symbol "Basket Status". If Carrots = 2, Fudge = 5, and Veal = 4 then the…
-
Countifs with Distinct?
I have two columns, Column A and Column B. How can I check Column A for a condition, and then count all the distinct corresponding values in Column B for which that condition is met? Is there an easy way to do this with Countif / Countifs and Distinct? Thanks!
-
My first VLookup
Hello, and thank you in advance for your help. I am having trouble displaying data using a VLOOKUP function (I have never used one). My formula reads as follows: =VLOOKUP(Predecessor@row, {PPPredTask}, {%Complete}, true) Its goal is the following: Based on the value in the Predecessor Column in my sheet, I would like to…
-
Date range calculation, count month numbers
Hi All Could I please ask for some help with a date formula? I'm working on an online education project. Each module takes around 6+ months to complete, see below the date range that starts on 14 July 2020 and ends on 25 Jan 2021. I need to count how many modules occur in January, how many in February, how many in March,…
-
Multiple Select Contact Column/Sheet Summary
I'm looking for a formula that I can use in Sheet Summary to identify individuals assigned to the same task via a multiple select contact column. The below is what I currently use to track daily tasks for individuals. Target Tasks =COUNTIFS([Due Date]:[Due Date], =TODAY(), [Critical Ops.]:[Critical Ops.], ="Yes",…
-
Lookup contact name from email address
Hi, Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address. I'm aware that I could achieve something similar by have a second sheet with Names and email…