Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated…
Hello Smartsheet Community, I hope you're all doing well! Im relatively new to smartsheets and I'm currently working on an automation process using the API's within Smartsheet where new sheets are cre…
Hi all This may be a silly question, but a quick google search seems to say this is impossible; I want to use a report to sum up all tasks overall/done/gone past deadlines, and then use a formular in …
Hello, SmartSheet Community! I could use your help. I have created an example of my problem below. The actual sheets have many more columns. Sheet A needs information sorted by Person Name; Sheet B ha…
Do we have any standard templates related to CRM in Smartsheet? Appreciate insights and advice from those who have undergone similar transitions or have expertise in utilizing Smartsheet for CRM purpo…
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the …
Hello, I have an automation where it send a request email automatically and it resends the same email 2 more times both request emails. I do it this way as a reminder and don't have to ask them to sea…
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the rec…