- Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
- Auto-Sorting Completed Tasks
I've done a bit of digging around, but wondering if I'm just not digging in the right places: What I'd like to do is set a rule that when a row is marked Done/Completed/Etc.. that it moves to the bottom of the sheet. Is there a way to create that kind of sort rule?
- Conditional formatting for how overdue something is
Hi all I am trying to use conditional formatting to change the colour of the date cell for when the date cell is over a week ago, and then another color for when the date cell is over a month ago. I think I may be missing something! So in effect, the cell would be normal when under 7 days overdue, when 7 days overdue it…
- Sheet row display error / mismatch?
Hi, I have noticed a strange formatting / display error caused I believe when text sizes other than "auto" are used. I have a sheet with conditional formatting that depending on a date in relation to today changes the font size (from auto to 14pt) to indicate that a critical date is approaching. I have noticed that the row…
- Conditional formatting on linked date cells
嗨,我已经创建了一个表与联系date cells from another sheet but have found that the conditional test 'in the past' does not seem to work in the linked cells. I assume this is a current limitation or has anyone got any ideas to resolve this? Thanks Jacky
- Conditional formatting for past dates dependent on other past dates
Hello, Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target.…
- Conditional Formatting Question
We use a Project Timeline Template that tracks the progress of each individual project. There are a number of parent rows with child rows beneath. I've created a status column so that each task can reflect the current progress via a harvey ball. I would like the parent rows to reflect the overall current status based on…
- Conditional Formatting Based on Date / Number of Days
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
- 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.
