-
Update request format - change to table view?
My team is new to Smartsheet. It would be great if I could send update requests that show up as a table view, rather than form view, so that the view is consistent for these new users. Is this possible? If not, can this function be added? Right now I'm using the workaround of publishing the sheet, selecting the rows to be…
-
GE GAL
I’m trying to figure out if there is a way to have the entire GAL (GE Outlook user database) accessible via the smartsheet, or by a user interacting with the request for update via a webform (or email entry). I have a user base that needs to log its interactions with other GE users so we can track activity for the team.…
-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
-
Priority rows
How do I insert a priority row and lock it. thanks Kurt
-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
RYG balls based on task completed
I have a sheet where I want to update the next columm based on the RYG color of the first. For example: If Column 1 = Green then I want Column 2 = Blue I think I am close on the formula but it just isn't playing nice. Thanks!
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
-
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
-
Calculating a Due Date
Frequently in legal transactions a transaction closing date may depend on the outcome of a couple or more previouls tasks. It will be the later of two or more previous tasks. Each task's completion date plus a different number of days depending on the task. The answer is the latest plus another specified number of days.…
-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…