Formulas and Functions
Archives for June 2019
Discussion List
-
Time/Date Stamp formulasIn Formulas and FunctionsHi, I am trying to auto populate a time date stamp when a cell is filled in on a row. Ex Submission Status then I need to create a formula to populate a due date based on the time date stamp and based on Priority Levels Priority Level …
-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)In Formulas and FunctionsI have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows …
-
Linking & FormulasIn Formulas and FunctionsI would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to…
-
Calendar View and ReportingIn Formulas and FunctionsOne of the project managers I work with prefers to work in a calendar view for the reports. I included snap shots of our Project Template, Report and Calendar View. Our process is to open a project template and name according to the meeti…
-
Calendar View and ReportingIn Formulas and FunctionsOne of the project managers I work with prefers to work in a calendar view for the reports. I included snap shots of our Project Template, Report and Calendar View. Our process is to open a project template and name according to the meeti…
-
Reports pulling from formulasIn Formulas and FunctionsI have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears…
-
Formula for Status change based on dates/ blank cells/ TBDIn Formulas and FunctionsHello all, I really found this community helpful so far in learning how to use Smartsheets. I just wanted to provide a formula I created in case it is helpful for anyone else. I didn't find the exact info I needed when trying to make it,…
-
IF AND Statement for Color StatusesIn Formulas and FunctionsI am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Cir…
-
Count tasks between today and xdays+todayIn Formulas and FunctionsI have several different project sheets that contain communication tasks. I create another sheet to create a count of tasks coming up in the next 7 days (I plan to create a report to pull up to a dashboard). I am having trouble creating …
-
Trying to expand my knowledge of writing formulasIn Formulas and FunctionsIm having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in t…