-
Help with Collect / Match / Vlookup formula
Working on a collection of sheets that I use between the different staffing agencies that service my operation. My Sr. Ops manager publishes a sheet (with the green shaded cells in the attachments below) with the labor order (by agency) each day for up to a week at a time. I am wanting to have the agency specific sheet…
-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
Updating an aggregation sheet/dashboard with weekly data
Hi all, I'm struggling to think of a way to aggregate data that changes weekly. I will try and describe as best as I can! We have a sheet that financial advisers fill in weekly (separate sheet for each adviser) to show various information as attached in the screenshot. The adviser updates this weekly every Friday, and adds…
-
Send Update - To update only selected cell?
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
-
Automation in Smartsheet-Responding to automated updates
I have workflows that automatically send update requests to my vendors when a task is 48hrs from its completion date. However, when they respond it goes to automation@smartsheet.com, and not to me where it should be? How can I change it??
-
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Creating different sheets based on one main sheet.
Hi everybody, I need to create separate sheets containing different information from one master sheet. But I also need to configure this in a way that if a new row is added to the master sheet, it will automatically be added in all other sheets that I created based on the master sheet. Any help is appreciated!
-
Date and month, linking cells
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. Original work sheet: 03/06/19 Linking work sheet: 06/03/19 I've double checked the…