-
Adding Date using 'Today' or 'T'
I just found out that you can use the function 'Today' or just type the letter 'T' in any 'Date field' in smartsheet and it will populate the date. You can also do simple addition or subtraction to calculate for dates. This is on every date field, sheet summary, forms, automation, workflow, rules, send as attachement and…
-
How can I append 2 columns together?
Hi! Just wondering how can I append 2 columns together? I have 4 columns: A, B, C, and D and each of the columns have 1, 2, 3, 4 values, respectively. What I would like to do is create 1 large column containing the values: A1 B1 B2 C1 C2 C3 D1 D2 D3 D4 If this isn't possible, this is what I'm trying to do. I have a 2…
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
Moving from Asana to Smartsheet
Can anyone share their experience in moving from Asana to Smartsheet? I'm looking for examples / visuals of what things looking like in Asana vs what they can become in Smartsheet. I've tried googling & looking on YouTube, but really only finding things about integrations between the two tools. Thanks!!
-
Smartsheet Expert
Hello, My name is Caylee Birkel; we have a cabinet design company in Nebraska that uses Business Smartsheet everyday and need help taking our Smartsheet needs to the next level. We don't want to upgrade our plan to anything higher than our existing plan. If you feel you can be of any assistance, we would love to hear from…
-
task cut
Hi everyone, I'm trying RM and I have this situation: Task1 has been programmed for User. While executing task 1, an urgent task (2) has been assigned to User. So, User needs to stop Task 1 and suspend it for a period. Must give priority to urgent task (2) How can I handle this in RM? Is it possible to cut the activity? It…
-
Phone Numbers and Street Addresses turn to Blue Font but only on Phone App
Hello, We have an interesting issue where all the phone numbers and street addresses we enter in a given row turn to blue font, but ONLY if viewing on the phone app. No matter what we do, we cannot figure out how to override this. It's an issue because a large majority of our conditional formatting relies on the use of…
-
Copying Parent Row into same sheet column of Child Row
Hi, Is there anyway that we can copy parent row into the child row and apply to the whole same column without changing the parent row information? For example: =Parent({Test]@row) works if I put into the child rows only, but when I convert to same column formula the information in the parent row disappears so the…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…
-
Need help in restoring sheets
Hi Guys, Need your help in restoring sheets disappeared from folder. I moved shared sheets which are not in workspace into a folder. Then I moved folder into a workspace. Folder moved but sheets inside folder disappeared. I moved folder back out of workspace to bring back sheets but still folder is showing empty. Folder…
