Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION. =SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete"))) The Priority column is a symbol column…
The current column displaying is the Primary Column. Ideally, I'd like to show information from a column formatted as a drop down.
How do I meet the following requirements? Using Request Tracker with Form Template - End user opens change request form - enters initial information related to the change being made. This begins a new record (row) which consists of the initial information provided through the form plus pre-defined "phases" .…
A function that gives you the row number of a cell as a number without using a workaround.
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
Greetings, Smartsheet Jedis! Is there a way of setting up an automation that alerts "specific people" as well as a "contact in a cell" whenever a comment is made on a sheet WITHOUT sending an alert to the person that submitted the comment? We currently have an automation in play that pings everyone whenever a comment is…
Hello - why are my comments being posted 5 minutes behind..........causing the updated comment automation to fail? My comments show being posted 5 minutes behind causing my comment automation to fail?
Hi, what is the best method to pull the status update from a different Smartsheet? Our technical team has a Smartsheet of tasks and I'd like those tasks and the status be reflected on the overall project plan. However, I only want them to be required to update one Smartsheet. Recommendations greatly appreciated!
Reports are great for sharing specific information from teams to leadership or external partners. However, it is a huge limitation for published reports not to have the ability to hide conversations. Conversations are a great feature for internal teams to be able to communicate on specific line items within a sheet, when…