-
SUMIF Formula - Incorrect Result?
Hello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM…
-
Formula to calculate the last update of a specific column
Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.
-
Automatically move item to different Smartsheet once completed?
I have a feeling that this solution doesn't exist within the current setup. Is it possible to move a row from one Smartsheet to another once the item is shown as completed? Thank you!
-
Marrying 2 sheet datasets into 1 row?
Hoping someone might have come across this scenario. I have a three-step process where a phone scheduler calls to gain info from the client, then a field rep needs to go onsite and gather info followed by a report generated from both parties. A primary key for both parties inputs will be a Policy # The phone scheduler will…
-
How to know which system admin added a user to Smartsheet?
We have 4 system admins, and now I see a lot of new people have Licensed users, are Licensed users, which should Not have happened. How do I know, which System admin added these users as Licensed users? Thank you, Deepthi
-
Pivot on contact list - returns email address
When I use a contact list in a pivot the email address is returned, I'd like to see the name so I can use the Pivot in reports and show the name, not an email address. Is this possible?
-
Attachments
Hi, I am having an issue with being able to upload attachments to Smartsheet. (Both admin and team members) Any suggestions as to what is wrong with the system? Kind regards, Kyle
-
Deleted user receiving notifications
Hello - I deleted a user when they left the company. They have just informed me that they are still receiving notifications through the app. I have checked and we absolutely deleted the user, there is no reference to them in user management. Any ideas? Many thanks for your help, Tim
-
Moving Row Automation - Not Working?
Hi there, I was super excited to see some of the new features that were released this week, specifically the automation to move rows!!! I set up the workflow automation according to the SOP from Smartsheet, but it is not working (at all). Not one line has moved yet... any suggestions/advice as to why? Thank you, appreciate…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
