-
Edit recurring report email
I set up a report to get emailed to a few people once a month. I would like to edit who is receiving this report, but I can't find the report schedule. I found a few posts about this but clicking on File—>Send as Attachment just allows me to set up a new schedule. Can anyone help?
-
Assigning people to day task based on roster rotation and OOO calendar
I would like to automatically assign staff members to day tasks based on a team roster rotation, while accounting for out of office days. Every day, I may need 1-10 people assign to the day task. Is there a good template for such an exercise?
-
Adding Column Descriptions to Reports
Hi Team, I added column descriptions to my sheets and created a report to present to my team. I would like the connection of the column descriptions between the sheet and report. Thank you, Justin
-
Export Cell and Row History
It would be great to be able to export the activity log for a single row or a single cell. Right now, the export of the activity log does not allow for easy filtering to a single row or a single cell within a sheet, and is limited to 90 days at a time. We document our project portfolio with each project as a single row, so…
-
MIN(COLLECT( function issues
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
-
Best Practices for EPMO Portfolio Dashboard as a start
Hi, I am setting up an EPMO Dashboard to track portfolio progress on our strategic projects, which use a mix of waterfall, agile, and hybrid methods. Since EPMO (one person) is a new department within a non-profit organization (around 75 staff members), one of our main goals is to create and maintain executive project…
-
Show Duplicates Based on Multiple Columns
Hi, I was looking for a solution to showing "Duplicate" if the combination of ColumnA @row and ColumnB@row of the same row appeared more than once. After taking bits of advice to similar problems in the community forum and reviewing the Smartsheet functions list, this formula solved my problem. I thought it would be worth…
-
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
-
Multiple "IF"
I want to write a formula for a different action for each of the 3 options in a column. If "Yes", count how many "Yes" responses in the next columns and find a percent for "Yes". In this case, Score is 60%. If "No", Score should be 0. If "Doesn't Apply", Score should be left blank. I think I am having problems with the…
-
Created Smartsheets in wrong region
I created my Smartsheet account yesterday using my Google email (patrick@diamondsolarllc.com). My company is based in the United States, but my account appears to have been created in the EU region (smartsheet.eu). I don’t mind being on the EU region as long as it does not cause issues, but I am currently experiencing the…