-
Update a cell in a row with current date when change is made to that row
I would like to know if I can have a cell in a row that updates with the current date when anything in that row is changed - kind of a "last time updated" cell. It will allow me to track stale rows. Thank you.
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
Count Info Across Multiple Sheets
Howdy! I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and…
-
Formatting With a Range of Dates
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
-
Prorate function and duration
Something seems to have happened with the prorate function in the new release, or perhaps it was always like this and I just never noticed (in which case I apologise). I use the prorate function to provide linear projections of task completion. In other words I calculate what the completion percentage of a task should be…
-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
-
F4 funtion in excel
Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?
-
Eliminate auto-numbering from child rows
Good afternoon, We are trying to create parent/child rows where only the parents has an auto-number, not the child. Is this possible? Perhaps we just need to use a formatting option instead of the column type as an auto-number. Blessings, Loann
-
Formula on Modified Date to Determine Days Since Last Modified
My sheet has a column for last modified. I'd like another column to give me the results from =today()-last modified so I can easily see how long its been since a row has been changed. If I use the formula above I get some decimal. If I use =(today()+"")-last modified I get an error. Any way I can do this?
