-
Setting Status column based on the number of "IS NOT BLANK" columns
Hello I'm new to Smartsheet and need some help. I'm tracking a project that for each participant, 12 different tasks need to happen to generate a complete data package. There's no set order for the tasks to occur, and there's no set time limit. I want to use the 0/quarter/half/full symbols to track the status of each…
-
Mail merge emails
We keep our customer contacts in SmartSheet now and send some emails to the list via our Outlook accounts. Is there a way to write an email in Outlook (or Word) and merge the email address from Smartsheet without exporting the sheet to Excel? We use Google Docs but not that much.
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
How can i create tabs in my Dashboard/Portal?
I watched the introductory video about Smartsheet on youtube and witnessed an amazing feature but I do not know how it was created. She had multiple tabs in her dashboard that functioned just like tabs on a web browser. Here is the link and time stamp of her using it. https://youtu.be/uGRFFavDm4Q?t=1524 . I have made…
-
How do you create a formula that calculates weeks out in certain cells based off one cells date?
Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working. I have a target end date and i want existing cells in a "task section" to calculate the weeks out based off that date
-
Merged: Grouping in Reports
This discussion has been merged.
-
Linking Google Slides & Smartsheet
I would love to see an enhanced feature, where Smartsheet and Google slides will integrate, and slides will auto-update. Any idea when this will be happening? Thank you!
-
Formula to determine is something is due this week
Hi all - I would like to calculate if something is due this week based on a target date in another cell. I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes") This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for. Is it possible to determine…
-
Date Formula: Calculate the number of days in a specific month between two dates
I'm working on a program tracker that includes revenue forecasting in each month. Project durations can range from one week to six months or more and I want the revenue to be forecasted evenly over the duration of the project. A date formula that calculates the number of days in a specific month between two dates would be…