-
Date Calculations
Hey y'all super new to this, I am trying to have the goal date be based on the Target open date less the days prior. The formula I have is " =Description1 + [Days Prior to Opening]@row " which returns the above. What am I doing wrong and how to do I fix it? Dependencies are turned off.
-
Update Column with Global Updates without Changing Position
I want to be able to choose whether or not the position of a column changes when I use the "Modify Column" global update. This can be very disruptive to my users if they have rearranged columns on their project sheets.
-
Looking for ideas to improve my current daily process re: managing references
Hi all, This is a very open question to see if I can get ideas from the community to improve my daily morning process with Smartsheet. Apologies for the lengthy question- this is outside of my usual very specific help request. I'm responsible for our Company's data; in the property insurance- independent adjusting world.…
-
Unexpected movement of rows - older post recommendations not working
I read an older post from someone else on this issue, but despite our best efforts, rows jumble unexpectedly and its such a significant problem we might not be able to continue with smartsheets. Here's what happens - we have a shared sheet showing our project schedule. Each project has a line and there are dependencies set…
-
Return Text that is in a Data/Number Column that captures dates
In the table below, I have 3 columns that are text/number fields: Final Document, Target Date, Actual Date. In the Target MM/YYYY and the Actual MM/YYYY, I have a formula to pull the MM/YYYY from the Target date and Actual Date, but as you can see, there is "On Hold" and "Cancelled" text instead of a date in some of the…
-
INDEX MATCH on multiple value cell
Hi, I have a column that can be filled from multiple items from dropdown list. On a second column, i'd like to return the matching items to those inserted in a first column. To achieve this, i have a second sheet with each individual item and it's match. Unfortunately when I try the index match formula, it only work when…
-
Are you able to hide specific rows from people on a shared sheet?
Hi, I am working on building a sheet for our CEO to track employees tasks and deliverables. However, he wants 1 sheet with multiple viewers (the team) and to be able to make the sheet so that each team member can only see the tasks (rows) they are assigned to and not be able to see any rows that are assigned to other team…
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
