-
Date Calculation \ Automated based upon cell value
Good day Everyone: I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date. trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops…
-
Sheet customization
Hello, Smartsheet team: I would like to know if is it possible to customize each sheet with its own logo and colors? Or you can only set a theme in general? Thanks!
-
Approval workflow with consolidated multiple rows
I am looking for assistance with a workflow that gathers approvals using multiple rows as the source. The challenge is that I'd like the approver to only receive a single email with all their required approvals. The data looks like this: Supervisor Employee Item Approve/Reject Debbie Kathy Pancakes Debbie Kathy Eggs Debbie…
-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
-
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
-
Populating Parent with Child Cell Info
I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible. We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair…
-
Viewing Sent Item History
Hi I had an inquiry from one of my colleagues. They would like to be able to view the history of single rows that they sent to a specific email. They had forgotten to cc themselves when they sent it and deleted the whole row by accident. Sent items cannot be seen in the Activity Log and you can't view the cell history once…
-
Facilities Maintenance Plan
Hi, Does anyone use SS for their facilities maintenance planning and tracking? If so, I would be interested in touching base. We are putting together a multi-year facilities maintenance program in SS and any help would be appreciated. Thank you, Archie Lopez
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
