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…
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 the…
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 v…
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'…
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 …
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 …
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 tea…
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 …
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 sel…
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 …