-
Child Text Indented formatting
When you have a Heading Row and Rows below that are Children of the Heading Row, is it possible to have the text Left Align and not be indented? Thanks, Tm
-
iOS app allows editing of some dates but not others
I’m traveling this week and only brought my phone and tablet. I downloaded the app assuming I’d be able to use it to edit my schedules, but for some reason some date cells are editable and others aren’t. As luck would have it, the active date cells are the ones I can’t edit, the “planned” date cells, which are permanent…
-
Combining IF formulas to Return Text Values
I have 3 columns; Start Date, End Date, Progress I can get the following formulas to work separately for row 17: =IF([Start Date]17 < TODAY(), "In Progress", "Not Started") Returns in the Progress column =IF([End Date]17 < TODAY(), "Overdue") Returns in the Progress column. I want to combine these 2 formulas in one cell to…
-
Recurring Update Requests until task is complete
I have a workflow where a contact is sent an updated request when they are added to the row. What I would like to know is how to have that update request sent regularly (daily, or weekly) UNTIL they have submitted the update request. Then I don't need them to get the update request anymore. Is there a way to do that?…
-
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…