-
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot of…
-
Data Shuttle Conditional Formatting?
Hi all, I had a chat with Pro Desk, and they couldn't come up with an answer for my question, so I'm turning to you all :) I have an Excel data source with project information that I receive every two weeks. One row = one project. One of three things could happen to this data source: Existing data updates Data is added as…
-
How can we automate a quarterly email with Smartsheet content in the body?
We have a Smartsheet with some content that I would like to format in an email in such a way that recipients are able to act upon information without needing to look at the Smartsheet. We have a list of Key Users in a column who I would like to send an email each quarter. If possible, I would like to include the name of…
-
Nested if helper column to set project size
Hi all, I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have: =IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium",…
-
Rouge Email Reminder from reminder@app.smartsheet.com
Hi everyone. I have automations set up for a sheet we've been using for some time now - several years. I will typically get Automations notifications from - automation@app.smartsheet.com I also get a notification from an email - reminder@app.smartsheet.com and for the life of me I can't figure out where this reminder is…
-
How to put in exact dates when tasks have predecessors linked
I have all my tasks linked to predecessors so that dates adjust correctly, but I am now unable to change the date to something farther down the line unless I unlink everything. Does anyone have an idea of how to fix that? Thanks
-
Is it possible to send ONLY an attachment as an alert?
Hello, Is it possible to send only an attachment as an alert WITHOUT the link to the sheet? I need to send them the file but do not want them to see or have access to the sheet at all. Please help, thanks!
-
#NO MATCH due to Smartsheet bug
I received this message after submitting a ticket to Smartsheet. As there seems to be no end in sight I'm curious if anyone else is having the issue and if they have found any solutions to resolve it? ---------------- I'm from the Escalations team here at Smartsheet Support. I was looped in explaining that you are seeing…
-
Predecessor Logic for a Specific Day of the Week
I am working on a project plan template that has a lot of dependencies enabled for dates, and many of them need to start or end on a specific day of the week. I have searched the community and see a lot of questions on this, but do continue to see that it has not been developed as of yet. I did try to search within the…
-
Trying to combine IF, OR, & AND
Hi all, As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written: IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement…