-
Formula that Automatically changes Date when cell changes
Is there a formula that would automatically change its date to reflect the date a cell or column changes? For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the…
-
Card View Stacked?
Hello, I understand why card view runs left to right. We are using card view to plan the layout of a 100 page magazine so we have 50 lanes. But there is only ever 2 tasks/cards per lane. Is it possible to stack the card view so we can see more lanes to view as visually this would be easier for us to manage this process?…
-
Problem Saving Blueprint
Hello Smartsheet, Reposing in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
-
Automatically request updates weekly without a trigger event
We have created a new Smartsheet for our quarterly goals including an Assigned To, Status and % Complete fields. We would like to have an Update Request send out automatically at 8 am every Monday morning asking for people to update their Status and % Complete fields every week. I tried going in and creating a new Update…
-
Assigning Multiple Tasks to an Entire Team
Hi I am new to Smartsheet, and hence am unable to perform the subject activity in it. I have a set of 25 tasks called "Proofreading Tasks". And I have around 15 people in a team which is called "Team - Proofreaders" . This team is supposed to perform these -- and only these -- tasks. Now how do I set it up in Smartsheet so…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…
-
VLOOKUP not allowing me to return value from beyond Column #20
Hello - I'm using VLOOKUP to return values from two separate data sets based on a unique identifier for my projects. For one of the VLOOKUPs, the column_num (column that I want to return the value from) is column 27. Why is it that VLOOKUP will return any value from columns 20 and below only?
-
Solicit Comments, but prevent user from viewing other's comments
Hello All, We use comments pretty extensively to communicate updates and share "next step" info internally. I would like to request updates, and include comments to external collaborators, but prevent them from seeing what has been previously posted. Is there a way to do this? Thanks, Alex
-
Will changing a sheet name break the cell links?
I want to change a sheet name, but it is the source sheet to another sheet with cell links. Does anyone know if the links will break, if the source sheet name is changed? Thank you, Bill
-
Sharing Reports without sharing sheets
We want to share reports with customers so they can see schedules but do not want customers to be able to view other customers schedules on the primary sheet. In order to share a report we must also share the primary sheet. Is there a work around for this?
