-
Multi- Row Solution
I am trying to create a workflow for an expense report that allows me to turn it into a PDF. Is there a way to utilize the generation of multi-row so I do not have to create columns for each individual expense?
-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
Ability to sort column property values in ascending and descending order
Often we will need to update/edit a column properties Values and when the new values are added, they are not always sorted in any particular order. Currently to workaround this, I open an Excel sheet → put the values in a column → sort the column. It would be a heck of a lot cooler if I could do that in when editing the…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Cross-sheet COUNTIFS Formula Not Working as Intended
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the one I am trying to create to count the number of projects that are due this week. I need to formula to count the rows that…
-
Formula problem
Hi! Before I start, I want to say that I'm still fairly new with formulas, so it's very very possible that this error just might need a slight fix, but I need a bit more assistance with what I'm specifically doing wrong here to get a better grasp of formulas. I'm trying to get a sum of how many tasks my vendor has…
-
Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
-
New Templates?
Hi Smartsheets Crew; I wanted to know if you guys are going to create any NEW Templates in your Solution Area OR 🤔 If you plan on ENHANCING / ADDING to your EXISTING ones (to utilize any/all recent changes to the software) since the Template(s) was launched? 😁 It would be great to see some fresh new ideas that relate to…