-
Is there a way to reference the row above?
I'm trying to mark active child tasks in an overall task. I'd like do =IF(Done@row-1 = 1, 1, 0) in the Active Task column, but we often insert tasks and I don't want to put a hard @row number in there that would need to be maintained when new tasks are added. Same for automatic numbers in a RowID column. I was also doing…
-
Trouble Opening a PDF Attachment
Hello, I have a PDF document attached to a row, and when I click on it to open, I get a link to get Adobe Reader, even though I already have it on my computer. Is there a way to get Smartsheet not to do this?
-
Report Parent, Child, and all Children under a Specific Parent
I've attempted to create formulas and helper columns to accomplish my task, but I must not be understanding how to get to my desired conclusion. I would like to take a subset of my overall project plan and report that based on a set of criteria. The challenge comes in that I want a scalable solution and I would like to…
-
Automation
I'd like to create an automation to send a notice to a coordinator when days worked are within 2 days of Days allowed to work. I'd also like to add a conditional format that highlights the row. Please help.
-
Product Usage Badges - Celebrating our Power Users 🎉
Are you an AWESOME Smartsheet user? We want to celebrate the power users of the Smartsheet product with special badges! Read on to learn more about them, and how you can qualify for each of them. These badges can't be requested. You'll receive an email letting you know that you've qualified, and we'll award them…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Control Center - include Intake sheet attachment
I've set up a blueprint and want to include attachments that are submitted on the Intake sheet to pull over to a sheet within the template folder. I've included "Intake attachments" from the "Intake Settings", however the attachments are not pulling over once the auto provisioning is complete.
-
Bulk upload for 100 contacts not working
This discussion was created from comments split from: Bulk upload contacts on Smartsheet.
-
Sheet Summary formula to included newly added rows
Hi, I created my sheet with some formulas at the top before I created Sheet Summary. Each day when new rows are added I am having to change the last number eg. 3861 to 3962. Is there a way to change the formula so the new rows are always included in the formula ? Current Formula: =SUMIF(Status19:Status3861, "Sent to Summit…
-
Dropdown list by Cell
I suggest adding a dropdown list option for each cell. We use Smartsheet for our Scrum process, where each user story has specific criteria. Having dropdown options would help my team easily track whether all criteria have been completed by simply selecting a checkbox
