-
How record a date automation work?
Hi, I'm having trouble using the record a date automation. as you can see in 1st picture, I create record a date when "send noti to slack" is checked in 2nd picture, every change I made in that check box is from 25-Nov-2021 but record date show 24-Nov-2021 does anyone know why? and what I have to do to make it record the…
-
Anyone else (Besides my team) having Smartsheet refresh issues this morning?
I am thinking the issue is on the Smartsheet side of things but not sure. This is the second time in 10 days for me, but the rest of my team is having issues as well. I have logged out of any sessions, cleared browser history and restarted my office computer (where I am remoting into and using Smartsheet). Does Smartsheet…
-
Import Outlook Calendar into Smartsheet
I was wondering if this is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
-
Is that possible that Smartsheet automatically writes hierarchy numbers for tasks level ?
-
Workaround for Sheet Reference Limit?
Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
-
Sub tasks appearing in an Uncategorised column
When I setup sub tasks in Smartsheets Card view, they appear in an Uncategorised column as separate cards. How do I stop this? Thanks
-
Forms with formulas
I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to…
-
Remove the "0" in the column formula cell.
Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column. See formula in Screenshot and the cells…
-
Dashboard Chart Widget Axis changes with each refresh
The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. I have a Support ticket in, but no good response. This is happening on multiple…
