-
Column Formula with VLOOKUP using External Reference
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false) I am getting an error message, and I think it's because of the…
-
Dashboard Chart to Match Current User Report - Multiple Project Owners
Hello, I have a follow-up to a previous question answered here - https://community.smartsheet.com/discussion/comment/263483 Some of our projects have two owners (two contacts in the requestor cell) so I'd like the charts to reflect the project on each person's dashboard. Currently, I have 1 project in progress and the…
-
Once approved, send attachment to Cloud Folder?
I have a sheet with a workflow that requires someone to approve the attachment. Once they do this, I'd like for the attachment from that line to be uploaded to a cloud folder. How can I accomplish this without reinventing the wheel? Bonus question: How can I define column values for that row as a string to use in the name…
-
Dependency
I am creating a project plan that is driven by the final deliverable date. For example, the final deliverable date is 4/1/2021. The first step needs to start 82 days prior to the final deliverable date, the 2nd step starts 75 days prior to the final delvierable, etc.,. Is there an easy way to create the plan using this…
-
Can you export report data into a new smartsheet? Instead of exporting to excel?
I am trying to generate a report from a master sheet we use for data retention in SmartSheet. I would like our project managers to generate a report and then export that report data with columns into a new SmartSheet. Is this possible?
-
Emailing a row from sheets does not show who is cc'd for recipient
Hi All, Something has changed recently in this process, it used to be that if I sent a row to Andy, Bob & Dan - everyone would be cc'd on the email received & when anyone responds, everyone gets a copy - and a group conversation occurs. Now, when we send a row to Andy, Bob & Dan, the recipient does not see that anyone else…
-
Multiple Users Updating Dashboards
Hello, Can multiple users edit a dashboard at the same time without losing changes one or the other person made prior to saving their edits? Thanks!
-
Update Request form - responses not updating smartsheet
Hi - We run a design review board every week and we use smartsheet automation to send an email to all attendees the day before the DRB, asking them to read the design to be presented next day and to then click on the Open Form button in the email and either accept/reject and add comments. My colleague showed me the email…
-
Remove conditional formatting from rows
Hi, Just wondering how to remove conditional formatting from specific rows. I am fairly new to using smartsheet but it seems like you can only do conditional formattings to certain columns but what if you wanted specific rows to not have the rules?
-
Regional Number format
Hello, In your regional preferences, you have predefined South Africa's English settings as : Apparently when we adopted decimal system many moons ago, the decimal separator changed to a comma, but honestly I dont know anyone here that uses a comma as the decimal separator. we use a full stop (period) like most of the…
