-
Stuck on a formula involving dates
Hello formula gods, I need your help once again. :-) I'm trying to write a formula that looks at 3 different date columns. 1. Look at the 1. actual completion date, if not blank then make it green, if it is blank then look at the revised due date column, if not blank then red for past due or yellow for reminder, if…
-
=SUMIF Month-to-Month
I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, "Green", {RSA Form Range 3},…
-
Parent Function working with dates
I'm trying to report down the same date as my parent date. Of course this simple formula is not giving me the results I need. I need the parent date for each job
-
VLOOKUP in Contacts Stops Halfway
I've been using the VLOOKUP function to populate contacts that I have saved in a separate sheet as my master contacts table. The names are alphabetical on both my destination and source sheets. When I drag the formula down on my destination sheet, it pulls the contacts but keeps stopping halfway at 'M,' where it says there…
-
Sumifs, vlookup, or date range
Hey I have some difficulty figuring out how to write a formula for my problem. My scenario is as follows: I have to sheets (see attached): * Payment sheet * Cashflow sheet The payment sheet is used to log payments to sub-contractors. There are a date column and a column for each subcontractor. The last column sums the…
-
sum hours assigned to a contact on a sheet for a particular month
Example: I have a project that lasts three months on a project sheet. I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard So for example: I need a formula that is going to Find all columns assigned to the contact…
-
RYG Symbols from 3 Columns
I am trying to return a RYG symbol based on 3 different columns(Decision) Approved, Needs Additional Information (Denied), or Submitted. Based on these 3 columns data, if any of them say "Need Additional Information", I'd like the Symbol (Status) Column to be the Red Symbol, however if all 3 Decision Columns are "Approved"…
-
De-Scoping/Deactivating Rows
We need a function where users can de-scope rows, thus deactivating that row and removing its influence on its parent rows. Is that an option via Smartsheet?
-
Can Pivot Sheets shared or embeded in iFrame?
Just try the Pivot Sheet in the smart sheet, that is the something I am looking for. But whether it can be shared or embed in wiki. Which I don't need to export the result and do the analysis in the excel?
-
Counting cells with formulas
My underlying issue is that I'm trying to count cells that begin with a certain number. The data that is present in my SubCategory column is a picklist. Examples: * 106 COST BILLED IN ERROR * 110 FAILURE TO PURSUE PAYMENT AFTER INVOICE SUBMISSION * 201 CLIENT FAILED TO COMMUNICATE WITH FIRM * 207 PER CLIENT - COST IS NOT…