Formulas
Discussion List
- I have a sheet that lists all active contracts for my department. The sheet houses the contract details such as Contract Name, Contract ID #, Vendor, Start Date, End Date and Extension Date, etc.… I a…
- I use Index Match to pull the project meta data from another sheet and one of the data elements to pull is the Project Dashboard Link, which is a hyperlink to a Smartsheet Dashboard. The link is not b…
- I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each pro…
- Hello. I am trying to create a formula that helps me to summarize the information on my master sheet so I can create a dashboard. I am trying to sum up the number of courses between published and arch…
- Hello everyone! I am hoping to get some tips/advice on using Index Match/Collect (I think is the right route). Currently, my company has one of our data sources tracked and managed through smartsheet.…
- So, I have a pretty complicated formula request: IF [Approved/Contracted Budget $$ (Total)] IS blank look in [Per Pt Costs (Submission)] Column and take that Number and put it in [Per Pts Costs (FINAL…
- Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more…
- I am using empty checkboxes to show a task needs to be done. Only certain rows will require this task. So I wrote a formula to auto check any box that will not need to be done. That way a report will …
- I currently manage vendors in Japan but need to also have currency in dollar for our finance/accounting in the US. I think the only current option is to change the whole account setting to change the …
- Hi, I'm stumped...I've tried this formula multiple different ways and nothing seems to work. Status column: Not Started, In Progress, or Complete % Complete column: any number (column is set to %'s) T…
