Discussion List
Summary Field Descriptions
Feedback: summary fields are a fantastic feature for consolidating reports on the same view as the detail. It is challenging at the moment to document the purpose and intent of each summary field, unless one adds the description to the summary field name. Idea: Add summary field descriptions (similar to columns) that can…
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
Record a Date when status changes
I have a set list of statuses that I want to keep track of and collect durations. For example, when the status changes to Sent to Lab (Ongoing), I want it to record a date in the Sent to Lab column. I feel like it should be an easy thing to do I just can't get it right.
Can I add Task name + Resource name on Gantt tasks?
This discussion was created from comments split from: Text in Gantt chart.
Configure availability for an individual. Apparently it exists, however I don't see this option.
Some of our people work 5 days per week others only 1 or 2 days. How do I set availability for each team member? I found this link describing what I need, however I don’t see those menu items. See attachment. Which Smarsheet icon do I click for Settings > Account Settings > People? On the bottom left corner of my…
Cell Link Reference not auto population new inputs from the source sheet into destination sheet.
I don't know what's going on but Cell Link Reference not auto population new inputs from the source sheet into destination sheet. I select the first cell of the column where I want my data pulled into and enter the column range from the source sheet using the cell link reference. However, every time I enter new data in the…
COUNTIFS formula for two Ors and one separate?
Hello, I would like a formula that reads COUNTIF the RAID Item Type = PMO or RAID Item Type = Change Enablement or if the Program Display box is checked. My formula currently works with the OR statement for the two RAID Item Types, but stops working when I try to add in the Program Display clause, as that is a separate…
Automation to change a cell value
Hello - I am trying to use an automation to change a cell value. I was originally triggering the change with a cell populated by a formula pointing to a cell with a cell link from another sheet, which I understand won't work. Is there a workaround for this? More detail: I am using smartsheet for headcount tracking in my…
Task Health, error applying formula
Hi All I have 4 columns on a sheet which are checked boxes, when they are all ticketed, i want the task health column to change to green. I am using this formula and applied it to the task health column but I am getting a circular reference. Where should i be applying to formula or is the formula wrong?…
Accumulative date formula required
I require a formula that calculates the PRODUCTION PACE of completed builds to number of days in the working quarter. Currently we are calculating the pace off the total number of days in the QTR (eg. 61 days from April to end of June), but this is not working for us as the pace is too larger for the actual pace we are…