I'm having trouble with a lookup-type function returning the wrong values.
We have our base sheet called the "Deal Tracker" where we keep tabs on the various deals that we consider (we're an investment firm). When entering a new deal, we always collect a Contact Name of the person who
Smartsheet does not use array formulas, but I need a way to list out items from one spreadsheet to another if a certain condition is met.
For example, I have an array formula that I used in excel that would look for a certain condition on one spreadsheet then pull all the rows of data that had that
I have a master property sheet that is updated with new property information. One of the columns in the property information sheet is "Sales Rep." I created another sheet that I want to track the list of properties for each sales rep. 1 sheet is setup for each sales rep.
I would like for the
I'm having difficult trying to report on metrics that would outline the following:
Identify the number of request types by project
For example, if you have 5 projects, all named differently and 2 request types (new/existing) and you wanted to report in a sheet, to then carry over to a
Hi, I am putting together a sumifs formula and it works for all criteria except this situation:
With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns.
This is my working formula with a single column
I have two sheets: Sheet 1 that people use to submit requests for course redevelopments and Sheet 2 that has a record of all 1,000 courses (with a link to the "master" in our learning management system).
We are in the process of standardizing the names of our "masters". Essentially, they contain
I have a column that shows when a ticket was created in Smartsheet. Now we just want a column that shows many hours have passed since the ticket was created.
What formula do you use to show the number of hours passed since created?
We have a Zapier zap hitting the sheet to wake it up every
I want to use below formula for remaining days;
=IF([Tamamlanma %]1 = "1", "T", [Hedef Tamamlanma Tarihi]1 - TODAY())
but when i use it , i cant see result ...
note: now i am using try version... so ı cant maybe is it possible?
I want to insert a couple of cross sheets formulas in the monthly data file that I add to smartsheet. It was easy to do but now I need to go back and add new columns and the formulas to past data files (several hundred). This is tedious but can be done over time. Is there any way to create a cross