-
Copy and keep cell value based on day of the week.
Hello All, Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed? Backstory: I currently have a dashboard with graphs that illustrates a rolling 7-day, 30-day, 60-day, and 90-day account interactions. I would like to…
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…
-
Advanced formula/function question.....
I am trying to write a complicated "if" function to search text and provide me with a result if any of the words in quotes are found in the text string. The formula works in excel but I cannot figure out how to replicate it in Smartsheet. Is there someone that can help? This is an example of the formula as it is written in…
-
Automation Email Notification
Can be possible if the automation email from smartsheet comes with a Customize sender information instead of the information of owner of the sheet? We created a ticket system and the automation email comes with the owners name and when the people reply to the automation email send email to creator of the sheet. We want to…
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?
Right now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to manually input new columns after the initial 12 week period is up. It's a time…
-
Marking Oldest 5 Projects
Hello! I have been working with some data and I want to eventually be able to pull a report of my "past due" projects and show the oldest 5 projects. To do this, I have created a helper column in my source sheet that using the formula: =IF(Date@row < SMALL(Date:Date, 6), 1, 0) in order to flag the 5 oldest dates in my due…
-
OR function Not Working with Multiple Logical Expressions
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as…
-
Anyone experiencing issues with Dashboard Published Links not displaying in Edge or IE?
Trying to deploy our COVID-19 Dashboard and during our testing we discovered that the Published Links (set to anyone with this link) will not display in Microsoft Edge or Internet Explorer. Anyone else run into this?
-
ENHANCEMENT REQUEST FOR DATAMESH and PIVOT
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I built as examples. I realize I can transfer the config, but that is not always the…
-
How do I find a smartsheet expert for hire to help build out our workspace?
Hello all, I am looking for a smartsheet expert, who can build a project template for us, including a dashboard for internal and external use. We are based in The Netherlands, but we can manage everything in English as well. So are you / or do you know an English speaking smartsheet expert, who we can hire for support and…
