Card View - Data Entry (Logic & Formulas do not show up)

I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does anyone know how to fix this...or did I miss doing something to make the card view work like the grid view? This could be a deal breaker for my client ......

Has any one experienced this?

Find more posts tagged with

Formulas

Conditional Formatting

Card View

Comments

Mick Jordan

Hi, could you give me a quick example of what isnt working the way it should?

Mick

Paul Newcome

It is working fine for me. In the below screenshots you will see a few rows of data.

The columns Start Time and Finish Time both have formulas in them.

1. Starting Data

2. Switched to Card View

3. Added new "Card" (did not enter data into Start or Finish time fields)

4. New card added

5. Grid view showing the new row added along with the formulas being auto populated

If yours is not working correctly, you may want to contact Smartsheet directly.

EcoPartnering

Thank you so much for your reply and all your community help. I am learning all of the in's and out's. I am creating a sheet for my team that will be doing data entry. Support advised me that needed to lock down the formula fields so people will not wipe them out in error because that was messing up everything I created. Lesson learned.

I did contact support to and asked for a feature request.

- ??We don't currently have the ability to show where a formula is listed while in Card view if the formula is currently not entered (would be entered by autofill), but I've let our Product team know about your request. We appreciate your input!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…