-
Summing values
Folks, I am looking for some help here. I am trying to calculate a value when the following conditions are met: If Billable = "Yes" AND Sprint = "Sprint 01" THEN SUM VALUE(Cell different sheet)/SUM ESTIMATES (this sheet where above conditions are true)*ESTIMATES value this row I have played around with multiple different…
-
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green Green = 0.9-1.1 Yellow= 1.2-1.3 Red = >1.3 =IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource…
-
Can we create a table in the forms of smartsheet.
I want to create a table in the forms of smartsheet.
-
Saving Error
I've searched the community for questions/answers about this, and while I've found posts that were started with someone having this issue, I do not see if what someone proposed (e.g., restart browser, check network settings) made any difference. I've tried these, and they don't fix the problem. I have a sheet with 1000+…
-
How do I set up a Report to only show specific rows assigned to a specific person?
I have created a sheet and a report. The report is what I want to send to certain individuals that will only show their rows that are assigned to them with their email address. When they access the Report with their email address, I want only those rows to show. I have a contact list column set up, but I am not sure how to…
-
Auto Export PDF from a Report
If I have a report that I would like to have automatically exported as a PDF on a daily basis, at a time that i choose, and emailed to specific contacts, is that possible? Appreciate any help you can provide
-
quickly move linked cells within the same sheet without losing linking
I have a metrics sheet that I use to generate a document that has the cells that are linked to a master sheet. We use it to display students by year. Each year we need to rearrange them in columns in the metrics sheet because they move up one year, the seniors leave and the freshmen come in. Is there a way to move the…
-
Copy Row Automation Not Working
Hi All, I was able to successfully build out and execute the Copy Row Automation on a test sheet. After trying to implement this on the live pages, it is no longer working. I'm able to manually copy the cells over, but the Automation is not working. Any troubleshooting suggestions? I am the Admin of both sheets and have…
-
Change the timeline view in Report widget
Is there a way to adjust the timeline view of the High Level Project Plan Report widget? Right now, it shows the gantt chart with a daily timeline - not exactly high level :) I would like this view to show one month per column
-
How to use a predecessor without resetting the date?
For example, item 1 and 2 on a schedule. Item 2 will start while item 1 is still going on, but will get pushed back if item 1 gets pushed back. Anytime I use a predecessor, it resets item 2's start date to the day after item 1 is complete. However, item 2 will start before item 1 is complete. I need a predecessor to…