-
Can Index Match pull over a hyperlink in a Children row?
I'm using this formula to pull info from one sheet to another based on an Asset #. One of the fields I'm pulling has a hyperlink in it. This seems to work on some rows but not others. Here's the formula: =INDEX({Asset Catalog Range 3}, MATCH([Asset #]@row, {Asset Catalog Asset #}, 0)) This formula woks for this row (see…
-
How to archive a Project?
I wanted to work on project archiving, I went through Help article. however cannot find project setting page itself. Kindly advise Many thanks, Archana Sahu
-
24 hour countdown
Does anyone know how to create a 24 hours countdown based on the created column? We need to trigger a notification or update request on a flag 24 hours after the row was created. We work in time zone globally and need to give the team 24 hours to complete their update request. Thank you in advance. Joe
-
How would I find how many references are being made to other sheets inside one sheet?
Thanks in advance for any answers. I am using smartsheets as an estimator currently and one thing I was worried I would have to deal with was the reference limit. I keep getting the "Incorrect Argument Set" error, even though I am just copying and pasting rows. I think it is the reference limit because it has not done this…
-
Project Tracking and Rollup - can't edit the plan sheet summary
Hi Community, I downloaded the Template Set - Project Tracking and Rollup. I have moved the template set to a workspace and now I am trying to edit the Sheet Summary for the Project Plan. I am not able to edit the summary -- I only can view the summary. How do I change to edit the summary.
-
Where did the row#'s go using @mention in automated tasks?
Formerly the @ mention notifications we received in Outlook included a row number. Here’s one from July as an example: By contrast, here’s one from today—no row number: Did Smartsheet change this? Thanks, Jeana
-
Expiration dates - how to monitor, notify, and track
I am a Safety Manager for a Crane Rental company. Background: We have a large fleet of semi tractors, pickups, service trucks, mobile crane, etc. Each of these have annual certifications, vehicle registrations, insurance card dates, vehicle service dates for various mileage related tasks (oil changes, etc.). I have a…
-
Will Published Items be index by google?
If I am publishing sheets, dashboard, reports etc. will they be indexed by google? If so is there a way to turn this off?
-
Avoid Overbooking a Training Resource
Hello, I'm looking for others who are using Smartsheet to manage their company's learning and development department. I manage a small training team that currently uses Smartsheet to schedule training. I am looking for a solution that will alert me when I am scheduling a facilitator that is already booked to teach a class…
-
How to get a notification when only certain users have modified a sheet
Hi, I'd like to setup a workflow to get an alert but only when certain people have made a change to a sheet (around 75% of the users who have access to the sheet). I tried to setup a workflow to look at the 'modified by' column, hoping I could hand-pick the users based on this but I can only run this workflow when this…