-
Alert
From a WEB Form - I'm searching for a way to send an alert by e-mail every 15 minutes to a specific "assigned", until a check box have been check. Is there a way?
-
Resource View per task (Portfolio Management)
Hello, I have a Smartsheet template containing a list of all projects in my portfolio. Each project takes one row, and in this row I have assigned PMs per project (up to three) including their allocations as percentage. When I go to the Resource View, I see the allocation per PM and when clicking in their names I see theā¦
-
Smartsheet Team Plan Offline and No Response from Support
Last week we cancelled a recurring PayPal payment approval on the PayPal site, so that we could register a different card as our preferred SmartSheet payment method for our annual plan. Although we didn't make any changes on the Smartsheet website itself, our Team Plan instantly disappeared and all Users were downgraded toā¦
-
Last Contact Date (Date Column)
Hi Team, I have a date column which I enter in the last contact date . Sometime I forget to enter the last date If i do an action..i.e. call, reminder, notes, e-mail etc. etc. Is there a formula that I can build (If I have to add a column and then hide it to make the formula/formatting etc. etc. work no problem) that canā¦
-
Update Request that uses cell color
Good Morning, I am using Smartsheet to track students that are Below Grade Level, On Grade Level and Above Grade Level. The cellĀ color for Below Grade Level is red, On grade level is light green and Above Grade level is dark green. When sending an update request for certain rows to one of my teachers, the colors in theā¦
-
Publishing read access sheet/report with common password
Hello all, We are facing a situation where we want to publish a report in reading mode to a group a people. We do not want the information to be public on the internet so the basic Publish is not an option and since the people onlyĀ access to this information couple time a year, creating a managing a Smartsheet account forā¦
-
Count, sum, average
I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certifications each person has, but that occurs in each row which throws off the average. In other words, =IF(Status1 =ā¦
-
Progressive sumif formula for calculate invoice progress
Over the course of a contract, I want to track how much has been invoiced and how much is left. If possible, for some contracts I know the invoicing is on a cycle and should be the same amount on say a monthly basis. I have columns for each month listing the invoice amount Invoice AmountĀ and a date column to be completedā¦
-
Project end date - Metric
Hi I am trying toĀ create a metric for a Sight sheet to show countdownĀ in days and another in weeks until a project starts can anyone help ? Cheers Neil
-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columnsĀ on that sheet to transfer to certain columns on "Projects". The columns do not directlyā¦