-
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Calendar for Media Planning
We are looking for a calendar solution to keep track for our advertising placements. We place about 100 ads per month, in multiple publications and multiple sizes. We would like to be able to see the calendar as a list by publication, publish date, deadline and as a standard calendar view. I checked out the templates but…
-
Conditional exclusion of rows
I want to have a sheet where based on a condition like a checked box certain rows are or are not available. For example if CAPEX is not checked then the Capex task rows are not available to see. Is this possible
-
Format date in project schedule to include day of week
Hello, Is there a way to change the format of the date within a project schedule to include the day of the week? Right now the format is 5/13/15, where it'd be much easier to read & use if it was Wed 5/13/15. any help is appreciated.
-
Recurring Task Lists
Is it possible to set up a recurring task list so that when I check a task as "done" the due date automatically recalculates to the next due date? Ideally it would create a new task with the new due date that was not marked as done. Thx.
-
Google Form to Smartsheets Sync (Update data)
If I have a form already created, and a user wants to update their submission, will that submission that changed the data be synced to Smartsheets or does Sync only work with new submissions?
-
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
-
Allocation for Project Manager
We are using Smartsheet with Resource Management enabled. We are tracking % allocation for employees and would like to do so for Leads as well. The idea is that the Lead would be allocated for the duration of task consisting of smaller subtasks at, say, 20%. We are using the Basic Project with Resource Management template.…
-
Recurring sending of a report
We find ourselves needing to send a report on a recurring basis on the 1st & 3rd Friday of each month. However, when there is a 5th Friday, we'd like to have the report sent then, as well. There is the option to send on the last Friday, but that would include sending whenever that's the 4th Friday. Currently, I have to…
