-
Populating Parent with Child Cell Info
I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible. We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair…
-
bulk edits
Hi i have a large sheet that needs to be edited by many individuals [circa 30]. Each row contains in a field the email address of the user who can edit or modify the record [row]. Is it possible to: automate an invite to edit based on parsing the sheet per unique set of emails restrict for a user to edit only those records…
-
Report Ques
Is there any way to merge two sheets of different data into one? See image - i want demographic data from one and then recorded actions from another sheet.
-
Issues with the new cross sheet formulas?
My totals were working finally on a summary sheet but then all the columns started changing to the same formula. I tried twice to go in and reset the reference sheet range but then it would just everything on the sheet. Anyone else have this issue?
-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
How do I - formula ques
I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
-
TIME OUT ON SAVE!
I am trying to insert rows in a formula-laden Smartsheet file ~2500 rows and the file will NOT save and keeps timing out. Whether wifi, ethernet, in the office, vpn......no solution Any thoughts on how to resolve?
-
What would the formula be for.....
I need to sum or count the number of people in my sheet that are under 17 and over 65, based on who is checked. Can I do this using a cross sheet formula so all my totals are together? I have both DOB and age columns - can the formula be on the age column or do I need a value column to set age parameters?
-
Looking for form creator - most secure and customizable
I've played with Google forms but don't like it's lack of customization and am not sure about the security. Are there other programs that are more secure that integrate with Smartsheet?
-
Contacts and Contact Groups
Can you share contacts or contact groups with other smartsheet users? Similar to how you share a filter or another way?
