-
Conditional Formatting Question
Hello Smartsheets Community: Does anyone know if there is a way for me to set a conditional format for the following scenario (use screen shot below): For task line 394 (highlighted in green), I want to turn this row red when the end date for this task is more than 5 weeks from the start of task line 386? Any help orβ¦
-
Calculating A Formula Question
Hello Smartsheets Community: Does anyone know why I would be getting a #INVALID when calculating a formula in a column that references two other columns with formulas in it? I thought you could calculate a formula in a column that references other columns with formulas in it? Is that not the case? Or, am I using the wrongβ¦
-
Return cell value
I would like this cell, Actual Ship Date, at the top to return the date in row 213 Task Start Date column. So the value should return 9/21/23. In excel, all I have to do it = and click on the cell. How do I do this in Smartsheet?
-
Formula to Read and Update from Other Columns
Hi All, I'm stumped on a particularly complicated Formula that reads multiple columns from a Sheet that not only displays the text needed, but will also be updated as the corresponding columns are updated. The formula in Excel seems to simply be =' which i presume displays the text required. Below i have added the formulaβ¦
-
COUNT TOTAL BASED ON TODAY()
Hi, I am trying to build a register for my staffs to calculate how many were present, sick, isolating etc., I tried to use the today function to calculate but it is not working. Any suggestions? Thanks Suresh
-
Can you return the data from a different column on the same row?
I have a portfolio sheet with multiple projects. The goal is to calculate which of these project studies are both the longest timeline and shortest timeline based on ""Deemed Valid Processing Days". I created a separate column for the formulas, I would like to pull results into a dashboard. Can I use a nested formulaβ¦
-
Detecting the unique items on a list
Hello all, Here is my problem: I have a list of items and I want to be able to create a list of unique items. I have 2 main columns Task No.(auto number) and Activity Name. I added 2 helper columns: helper-duplicate and helper-unique. The helper-duplicate shows the amount of duplication each row has based on the Activityβ¦
-
Update Automation not running correctly
Hello, I have some simple update automations on a project that we are having trouble running properly. The update request is set to send out a request for update to both a Supervisor column and a corresponding Senior Supervisor column so that if the supervisor is not here that day, their senior supervisor can fill in andβ¦
-
Its a question of time....
Hi all, I know questions of handling time keep coming up and I have one of my own. I have a sheet that calculates downtime for machinery. I used some formulas Paul Newcome listed and they were a HUGE help. What I have now is a Downtime Start date column and a Downtime Start time column and corresponding Downtime Stop Dateβ¦
-
Help finding and collecting matches
Hi, I have an task I believe Smartsheet can do but I've had no luck figuring it out. I believe the solution lies with formulas of vlookup, match, index and possibly collect but for the life of me I'm stumped. To simplify what I'm trying to do - in essence I have a Smartsheet grid filled with data on what foods people like.β¦