-
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
-
Help with Formula!
Hello, I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please? I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula…
-
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"…
-
Formula for a future meeting date (after today)
Good morning - I have a series of columns with scheduled "future" meeting dates. I want to populate one column with the date of the next scheduled meeting. Have tried importing the formula which works in Excel over, but Smartsheet keeps on saying "INVALIDOPERATION. Help please !
-
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…
-
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…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
#INVALID OPERATION (SUMIF/SUMIFS to blame?)
The formula I'm trying to fix was not reporting our information correctly so I built a new formula in a test environment and it appeared to be working as intended only for me to find that when applying it in a live setting, the result was constant #INVALID OPERATION errors. The formula is this: =IF([Est. Annual Rent]@row =…