-
AI Text and Summaries Column Formula
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature! One thing that has been cumbersome about it has been that in…
-
Multi-row intake form
Hello , is there any way you can have multiple row entries in a single intake form?
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Row ID / Row link
I'm building simple asset tracking system with Smartsheet and would like to have the row links as QR-codes that would then be printed as asset tags. I have not been able to find a feasible solution for pulling the row links for each asset (row). Doing manual copy paste for >2000 rows is not very convenient. I have a column…
-
Viewer Vs Paid Membership?
Do you have to have a paid Membership on Smartsheet's to access a link in a worksheet? Or Can you just be a Viewer and still have access or open a link on a smartsheet?
-
Formula to calculate a future date on a specific day (monthly and quarterly)
I have tasks that need to be completed monthly and quarterly. The due date of these tasks falls on specific days of the month, either the 5th, 14th, or 15th. I have a formula that calculates the Next Date based on a Due column and a Frequency of Submittals column. Next Date and Due are date columns. My basic formula to…
-
Have I stumped Smartsheet AI on calculating dates??
Hello, I have a sheet set up to track of the number of event reports received on team members (mock example below - my real sheet has goes up to Event10). The dates are entered manually but every time I enter the date, I want to calculate the number of event dates that fall within 3 years of the latest date I just entered.…
-
Counting tasks completed on time
I need a formula that says, if the "Complete?" box is checked, was the date in the Actual Completion column on (or before) the date in the Finish column.