-
Formula for auto flag
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end date] - today()<=7,0.5.0). It turns the flag red when it falls into the not 80% complete in the time frame but when there…
-
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
-
automatically send web form daily
Hello, is it possible to set a webform to be emailed daily so that the person can fill it out every day and add a line to the sheet? (this is for a timesheet).
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Tasks in Resource View
Is it possible to view the task or sub-task assigned to a resource in a resource view? We use a multi-project sheet to encapsulate schedules and would like to track resources within a sheet as opposed to across sheets. As you can see in the screenshot, the resource view only shows the sheet name instead of the task, which…
-
using IF together with AND
Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete" I have got "in progress", "overdue" to work by the following: =IF(TODAY() <…
-
Value between dates
Hi Everyone, New smartsheet user here, I am trying to get a total cost between dates on a running construction schedule. I have different row-categories (Land acquisition, permitting, site work, construction, & selling) with columns showing start date, end date, and cost. All costs are positive, revenue (selling) is…
-
SUMIF formula with range
=SUMIF([Total Sales of Goods and Services]@row :[Total Sales of Goods and Services]@row, [Payments in Quarter]@row = "Q.3.18")) The purpose of this formula is to sum all totals of Total Sales of Good and Services if the Payments were made in Quarter 3, 2018; I'd like to make this formula workable per selected quarter for…
-
Having viables on a form
I have a form that my company uses to enter new jobs on our manufacturing schedule, However we also do a select amount of installs. Is it possible to have the form be able to have a drop down menu (this i know it can) that when The questions is "Is this an install" the user selects "No" then all of the Install questions…
-
% Rool-Upon another sheet
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a specific subcontractor into a…