-
Status View
Hello, I am hoping someone can see what i am missing here :) attempting to try out status view .. We would like each part of our group have a different status view in order to see only what pertains to them . and a place for them to fill out a request form. I created a status view - see image 1 ... and i have already added…
-
Batch rename hyperlinks
Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do this one by one. (multiple sheets with the same set up). Thanks
-
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?
