-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
Use more row content as the default text of the subject field when sending a quick update.
We would have a huge increase in productivity if we could use more than just the primary column row content as the default text of the subject field when sending a quick update.
-
Allowing for unresourced time requirements
I'm evaluating using SmartSheet for project managing construction projects. So far, so good. One of the requirements is to allocate time for processes such as plaster drying out. So no resource is required, just a number of calendar days, which can include weekends/holidays. I can set up a "task" for this with dependency…
-
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…
