-
Licensed User to send an email for a row?
Do you have to be a licensed user to email a row? If that was one of the "new" changes for the unlicensed user, I did not see it in the email.
-
Using Join/Collect to Collect from Another Sheet, Two Criteria
In Sheet 1, I want to identify the color of the title of a book that matches ISBN number, so long as the book is available in the library. Sheet 2 Available | BookTitle1 Unvailable | BookTitle2 Unvailable | BookTitle3 Available | BookTitle4 Available | BookTitle5 I want to look for a value (e.g., BookTitle__) and display…
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
-
Notifications using Summary Sheet
If I create an automation workflow to notify all contacts on a sheet, will those listed in the sheet summary be included?
-
IF statement to pull value from another sheet if a checkbox is ticked
Hi all, I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets. I have a column in my risk register with a checkbox that gets ticked when a risk has become an issue. I want my issue register to have a column listing the…
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
Using IF formula to set conditions for RYGB ball color
Hi there! I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just change the color of the cell, which is why I'm using formulas instead of the conditional formatting. I keep receiving the…
-
Nonworking Days but tasks must be completed
So I'm setting up a smart sheet so that I have a holiday break for Christmas and Thanksgiving. My problem I'm having is that when I go to start one task after the next, it'll start a task and carry it through the holiday break then complete it after the break. Is there a way to set it so that if a task won't be comlpleted…