-
sequential letters
I have a sheet where I have parent and child rows, and I would like one column in the child rows to have sequential letters. I have a picture here. I have a parent/child column that would normally be hidden, but I count the number of children so obviously the parent will have a number greater than zero and the children…
-
Why does my Modified Date keep updating when I'm not making changes?
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows at all. In many cases those rows are filtered out of my view, so it's not even…
-
Not sure how to write formula correctly, not even sure this is a SUMIFS
Hello, Apologies for yet another basic question, but I'm having troubles wrapping my head around how to get a formula to behave a certain way. I'm still working on a PTO manager tool (requests PTO, automated approvals, and auto calculations on PTO Balance, etc...). I have 3 total grids (Submission grid, Track grid, and…
-
MULTIPLE AND ON MULTIPLE COLUMNS wANCESTORS
Hi there... really need help 😯 I have a list of actions, all actions are either a PARENT action (Outdented) or child actions (Indented). I added a column with =COUNT(ANCESTORS()) to have 1,0 depending on the case. I have another column with a "Due date", and another with "Completion Due Date" where I want to monitor PARENT…
-
Circular Reference Warning When Linking
I'm receiving a circular reference warning when all I'm doing is pasting as links to copied cells. Any ideas for why this is occurring when many other places in the sheets are able to be copied in this same manner?
-
COUNTIFS with other IF criteria and referencing other sheets
Hello! Context: I'm leading the charge on tenant migration for a datacenter over 7 weeks. There are 10 teams (each with their own inventory sheet) and hundreds of services among all the sheets. Goal: track completion metrics across all teams, one week at a time. This would include total number of services and number of…
-
Force upper case on a column
Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font in it. Thanks
-
Limit number of rows in Smartsheet?
Hi there, Is there a limited number of rows in one smartsheet? If so, what is the number? Thanks! Mike
-
IF Multiple values selected THEN VLOOKUP and return values
Is there a way to return values in a cell if multiple criteria is met? I would like to track the amount of time our Onboarding Coordinators spend on tasks for each Country. So when they create a contract in Austria it takes 60 minutes but for Croatia it takes 50 minutes. For a contract to take 60 minutes, date fields…
-
Auto-Fill Rows of Data Based on Criteria
Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country selected, the fields below would populate based on the values from another sheet. Example, If Austria is selected then the…