Formulas
Discussion List
- I'm using Jira Connector, and the Jira Label field in the source Jira project can contain multiple values, which get populated in Smartsheet Label column as comma separated strings for each Jira issue…
- Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch an…
- I have a list of dates that are Quarter/year (in a format like Q4 2031, Q1 2038, etc.) and would like to use a formula to show the last date in the quarter. So: Q1 2031 = 03/31/2031 Q2 2027 = 06/30/20…
- I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation o…
- I am working on pulling historical data from another source sheet but I only want to evaluate the data within the last year. I am having problems with getting the formula to pull information. I am att…
- The left photo is my metrics chart, and the right side is where my data is coming from. Im trying to create a formula to pull from that specific cell, and reflect that same count onto the metrics shee…
- Hello All, I have a form collecting construction progress updates. When a from is submitted, I would like the "Construction Report" on a separate sheet to have a completed date (equal to submission da…
- We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column …
- Trying to find replica of excel's Xlookup formula. Here is my current formula that is not working: =INDEX({GP% TO PAY}, MATCH(MAX({HIGHEST TIER%})([% to GP Budget]@row, {HIGHEST TIER%}),0)) I am tryin…
- I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each i…