-
Stoplight formula help
Hi all... I've gotten some good help on this forum before, so hopefully you all can help me out. I'm trying to create a stoplight formula for tasks in a project plan. I would like to trigger colors of red, yellow, green based on the percentage complete of that task, and how far we are from the expected finish date of that…
-
Formula to Hyperlink contents of a column into another
Hello, I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column? I have the need to hyperlink a few hundred rows of data and want to avoid the manual hyperlink method (copy URL, cmd K , paste link etc...)
-
Adding Teams user data to a Form
Hello, I'm wondering if anybody knows if there is a way to pull in somebody's Teams user data into a smartsheet form. I have a Form that is published in Microsoft Teams and has a couple of drop down boxes for people to use. One to identify themselves, and another to identify another employee. I'm trying to create a way so…
-
Project intake from non owned non admin shared sheet
I am new to the smartsheet program, and learning quickly, but I have a new problem I am trying to work through. I have shared access to a vendor smartsheet that does one piece of my customers work. This shared is a tracker that has multiple sheets funneled into one sheet. I am wanting to import key information from their…
-
Automation for missed daily log
I've got a sheet that is a daily log for the check of pool chemicals. We've set up some automation to trigger if the values drop or exceed certain thresholds. However would also like to trigger a notification if the frontline staff forget to record the daily readings. I tried trigger when a date is reached (Daily) and if…
-
Cross sheet query
I have a number of project sheets and master sheet with summary details of each project. When I complete a certain task in an individual project sheet I would like that to tick a check box against that project entry in the master sheet. Is that possible? What formula do I need? Your advice would be much appreciated - thank…
-
Syncing multiple Smartsheets into one master sheet
Hi, I've got multiple sheets for individual projects that I wish to collate into a master sheet. The sync needs to be two-way, so if you update a row on an individual sheet it also updates on the master and vice versa. I'm currently achieving this using Unito, but it's getting super expensive so I'm hoping there's a way I…
-
LABOR EFFORT PROJECTION
I need help figuring out how to calculate how much labor cost for a particular task will be at the end date based on - - column 1 - start date - column 2 - end date - column 3 - current labor spent Initially I'm thinking I need to take the current labor spent to date and divide between today and start date. then multiply…
-
How Many Times an Item was Sent by a Specific Date
Hi, I am working on a project where we are trying to identify how many time a report was sent by the last day of the month, after the last day of the month and not sent at all. I am struggling on how to put this together because we would like to be able to display this information on the dashboard. I have included a screen…
-
Sheet Summary Formula
I have a formula that totals the number of sales per project manager broken down by month: =COUNTIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 9) I need another formula to Sum those sales for each month based on the column "Amount Awarded." I feel like this should be a fairly simple formula, but I have not…