- Can you cell-link within the same sheet?
我的团队是tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
- Why is Resource Management Synchronization showing up on my activity log?
Hi all, I just noticed that my activity log is showing that Resource Management is syncing with an API, but I never set it up to do so nor do I even have access to RM. I noticed this on my other sheets as well. Can someone tell me how this is happening? Thanks! Brad
- COUNTIF formula counting specific criteria under a PARENT row
Hi All, I have a shipping tracker I created for six different stages we're doing for a project. I need to create a graphical representation of the different statuses for each stage and type. The formula would read: Count of "delivered" for "POM to IHA" under "WW01, as one example. A separate formula would be Count of "In…
- How to change task bars of parent rows in the Gantt chart?
I set conditional formatting to change the task bars for each of my categories to the color that is represented in the Grid view. However, only the child rows are showing the bar color and not the parent rows. How do I get ALL the rows to show the color(s)? Thanks!
- How to decide when to use Smartsheet over Excel and vice versa?
Hi All, I am doing my first "training" for one of my teams within my company. Right now (like many people who don't currently use Smartsheet), they are mostly using Excel to gather and analyze data, create schedules and timelines, and for reporting. One of the questions they want me to answer is deciding when to use…
- My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?
Hi, I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what... =COUNTIF({Cross-site IHA Yes}, 1 / COUNTIF({Cross-Site IHA Ask 1}, 1)) Essentially this is saying, count all the "checked" boxes in column 1 and divide them by the number of boxes "checked" in…
- How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…
- Conditional Formatting Cloning
Hi SS Community, I have a colleague who has a sheet with a ton of CF rules (which are applied to months/years ie. June 22, Jul 22, Aug 22, etc). He would like to clone a rule and then change the "condition" part to different month so the same formatting will apply without having to manually re-enter the rule. ie. If " Test…
- What are other alternatives to Bridge by Smartsheet?
Hi SS Community, I have a major project in which I am responsible for managing and overseeing shipping and tracking of parts going to other countries from our facility. I have talked to my team about Bridge, but it seems the cost is quite steep at this time and proposed searching for an alternative that we can use in…
- Resource Management Pricing?
I need further clarification on the pricing for Resource Management. I've been told that in order to sign up (within an organization) there needs to be at least 45 people signed up at one time. Can someone verify this? Thanks!
