-
Automatically create multiple rows in a smartsheet
I'm creating a couple of web forms with a single smartsheet. Each one will capture slightly different details. The forms are sort of like a helpdesk queue, where the users can have different requests, but ultimately all the work goes to the one helpdesk team, and the work is all 'queued' into the smartsheet, and from…
-
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
