-
Calculating a date from another date in same row
how do I have the start prepping date calculate off the meeting date automatically in the same row. ie I have a meeting on 1/22/18 and I need to start planning 10 weeks prior and would like it to be automated. The problem is this is a major calendar for over 30 meetings, and all have different lag times for planning. I…
-
Need help with a recurring report formula
Hi. I am new to Smartsheet and it has been a while since I have done alot with formulas in Excel. I am setting up a report tracker for our organization that will have recurring reports due on a weekly, monthly, and quarterly frequency. I need some help with a formula to automatically adjust the next due date so that…
-
Linking
I was wondering if smartsheet linking has the capability to perform this following type of function: If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of…
-
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
-
RYG Balls connected to Whether Items are completed or not.
I am looking to connected RYG balls to whether certain items are complete or not? I am not sure of the best way to do this- if a checkbox would be the way to connect color change based on status of task, or if inputting a "completion date" would do the same thing? I tried a couple of different formulas from these forums…
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
Comparing 2 date fields and setting symbol
Hi. Just getting to grips with Smartsheet. I have pairs of date fields: Forecast Date and Actual Date. I would like to set a red status symbol if the Actual Date is past/older than the Forecast date. How can I do this? Alternatively I can set a check box if setting a symbol is not possible.
-
Combine formulas referencing the same cell without running into a circle reference
Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function. I would like to combine the 3 formulas below for efficiency sake rather than creating additional columns. =SUM([column name]24/ 1000) =ROUND([column name]24, 1) ="$" +…
-
Adding a $ to a Reformatted Number ending in "M" (Millions)
Hi, I am trying to convert a number in millions but shown as a thousand to the nearest decimal point and then add "M" to the end of the converted number. I understand the formula to divide by 1000 and then use the ROUND function to get one decimal point,but when I concatenate the "M" at the end I loose my dollar sign. Does…
